Post reply

Korean language not displayed correctly in SQL Query Analyzer

  • 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

  • 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

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

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