Korean language not displayed correctly in SQL Query Analyzer

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Globalization » Korean language not displayed correctly in...

Korean language not displayed correctly in SQL Query Analyzer

Rate Topic

Display Mode

Topic Options

Author

Message

jikur

Posted Monday, October 20, 2008 8:57 PM

Forum 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

Gift Peddie

Posted Thursday, February 19, 2009 2:44 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

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 »

Permissions