Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
actuary
Starting Member
23 Posts |
 Posted - 2008-12-15 : 10:19:48
|
| Hi, I have a table that stores text in a nvarchar column. When I insert japanese data, it goes in as "<p>#12531; #12362;#12424;#12403; #22269;#21029;#12522;#12473;#12463;#20104;#22577;</p>"And displays properly in the page since its utf-8 format, now I want to use this data in sql server. Is it possible to apply some kind of trick to display the correct text within a transaction (no webpage display needed). E.g change locale settings to retrieve the data or something like that?Just spotted that the japanese is displaying properly in the ticket. Whereas the text that goes in the table is something like <p> '&-#-1-2-5-3-1-;' '&-#-1-2-3--6-2-;' '-&-#-1-2--4-2-4-;' '-&-#-1-2--4-0-3-; ' (without the ' and -). Why would'nt this go in the nvarchar column as japanese?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 10:33:19
|
| does your code page support japanese characters? |
 |
|
|
actuary
Starting Member
23 Posts |
Posted - 2008-12-15 : 10:46:37
|
| yes, the page I use to enter the data displays japanese when I enter and retrieve, I assume that's what you are referring to here. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 11:19:07
|
quote:
Originally posted by actuary
yes, the page I use to enter the data displays japanese when I enter and retrieve, I assume that's what you are referring to here.
nope i was asking about collation of your sql database. does the codepage of used collation support japanese? |
|
|
|
|
|
|
retrieve foreign language