Korean language not displayed correctly in SQL Query Analyzer

• jikur

  SSC Journeyman

  Points: 91

  October 20, 2008 at 8:57 pm

  #194752

  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

• Gift Peddie

  SSC Guru

  Points: 73570

  February 19, 2009 at 2:44 pm

  #947173

  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