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 |
lorraine1000
Starting Member
6 Posts |
Posted - 2008-07-17 : 12:54:30
|
Hiok i run ms sql for an online game the game supports english, korean,language now we have just got alot of korean players join the game but they dont speak english the problem is when they do anything that logs to the ms sql database the korean writing does not come out right, is there a korean language pack that would have to be installed or have i done something wrong here, the main OS is set to use korean, and i have all the unicode install on the OS, but it is set to use english uk as standard.can standone help here pleasemany thankslorraine |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-17 : 13:49:26
|
what is collation setting for db?does that support korean characters? |
 |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-17 : 14:18:30
|
are you using nvarchar instead of varchar columns?_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
lorraine1000
Starting Member
6 Posts |
Posted - 2008-07-17 : 15:44:28
|
ok the server collation is set to SQL_Latin1_General_CP1_CL_AS and it is using nchar, Many ThanksLorraine |
 |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2008-07-21 : 16:32:42
|
How are you inserting the text data?Are you preceding it with N' ? |
 |
|
|
|
|