Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Korean language not displayed correctly in SQL Query Analyzer Expand / Collapse
Author
Message
Posted Monday, October 20, 2008 8:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 30, 2009 11:12 PM
Points: 1, Visits: 27
Hi All,

I have some problem in displaying Korean Language in SQL Query Analyzer. It come out correctly if I view the data in SQL Server Enterprise Manager (table name >> open table >> return all rows)
The chinese characters are showing okay on both.

Any idea what could be the reason?

I have set the regional setting for Korean and Chinese.

Thanks.

Cheers,

Jikur
Post #588921
Posted Thursday, February 19, 2009 2:44 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411
The Korean and Chinese languages comes with more than 2500 character alphabets so it is not practical to use the latin alphabet to render Chinese, Korean and Japanese. So need to use the correct collation, with NChar/Nvarchar and NText data types. Check below for your collations.

http://msdn.microsoft.com/en-us/library/aa176553(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/aa258233(SQL.80).aspx



Kind regards,
Gift Peddie
Post #660891
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse