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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 can anyone help me here with lauguage problem

Author  Topic 

lorraine1000
Starting Member

6 Posts

Posted - 2008-07-17 : 12:54:30
Hi

ok 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 please

many thanks

lorraine

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?
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-07-17 : 14:18:30
are you using nvarchar instead of varchar columns?

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

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 Thanks

Lorraine

Go to Top of Page

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' ?
Go to Top of Page
   

- Advertisement -