Store Thai and Korean Characters

I think setup your database collation/encoding as unicode, then can store any language, well almost.

Hope this helps.

Regards,

How can I do that? I have tried to set the Windows Collation to Korean_Wansung_Unicode, it didn't work :(
Could you lead me on how to do it as unicode?


Regards,
rospcc

select * from ::fn_helpCollations() will give you the list of collations available
Also do u have Korean font installed on ur computer

Hi,

More information, I just tried to use SQL Syntax and execute from the Enterprise Manager direct, it was being updated as ???????, not the exact korean characters.

UPDATE    CriteriaDetail
SET              CriteriaDesc = 'ㅇㅁㅁㅇㄴㅎㄴㅁㅎ옿ㅁㅁㅇㄴㄹ'
WHERE     (PKCriteriaDetail = 604)

try to update it from the front end.

oo actually the CriteriaDesc that I posted was in Korean Characters, I didn;'t know it is being shown as ㅇㅁㅁㅇㄴㅎㄴㅁㅎ옿ㅁㅁㅇㄴㄹ

Anyway, what do you mean by front end? Updating through JSP itself?

Regards,
rospcc

yes.. try to update thru the JSP page and retriew the data and show it at the front end. This is just for testing

This is the first way that I did, and it didn't work. I used UTF-8 as the encoding, and it was stored as question marks ?????????

I can input Thai from JSP, encoded using UTF-8 as well, it is stored correctly in database. But for korean, it just didn't work.

Ok, Let me try

try this
https://www.experts-exchange.com/questions/21210954/Korean-characters-appearing-as-characters.html

Also read this document
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp