October 20, 2008 at 8:57 pm
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy