Korean language not displayed correctly in SQL Query Analyzer

  • jikur

    SSC Journeyman

    Points: 91

    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

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply