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 |
|
greatJ
Starting Member
1 Post |
 Posted - 2007-08-17 : 03:16:17
|
| Hi experts,I want to store japanese characters in one of my database tables. I copied some data including japanese characters from an excel sheet and pasted it to the table. that works fine. The characters are also nicely displayed in my web application. But I am unable to type in new characters to the table. When trying to do so, even the windows language bar does not allow me to write japanese characters!I changed the collation of the database from Latin1_General_CI_AS to Japanese_90_CI_AS_KS_WS. I also played with the collation settings of a single column in the table, setting it to different Japanese Windows Collations. The values in the column are stored as NVARCHAR.The strange thing is: When I insert a new table to the database then I can enter japanese characters without modifications, the table having the same properties as the one in question (at least as far as I can see).I am stuck here, does anybody have a hint how I can solve this issue?Additional question: Which collation should I take?Thanks a lot for you answers!JJ |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-17 : 04:16:38
|
Data already in the table is NOT affected with this change. The characters have already been converted to fit the first collation.After changing the collation, you have to import the data again.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
SOVLED -- Storing Japanese characters