Store Thai and Korean Characters

Hi,

Can we store both Thai and Korean characters in one table in MS SQL Database?

Regards,
rospcc
rospccAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
Yes, you can store data in two differrent nvarchar columns
0
 
J2811Commented:
I think setup your database collation/encoding as unicode, then can store any language, well almost.

Hope this helps.

Regards,
0
 
rospccAuthor Commented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Aneesh RetnakaranDatabase AdministratorCommented:
select * from ::fn_helpCollations() will give you the list of collations available
Also do u have Korean font installed on ur computer
0
 
J2811Commented:
Eh, ok this is a very elaborate discussion for which might be beyond me to try to explain in EE.

BUT, all is not lost, read this article,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_6ttf.asp

And also read the links at the bottom of the article that talks about collation.

Basically to answer your initial question, YES you ca store both Korean and Thai in one table, theoritically, even in the same (nchar, nvarchar) column (have not tested this out).

Hope this helps.
0
 
rospccAuthor Commented:
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)

0
 
Aneesh RetnakaranDatabase AdministratorCommented:
try to update it from the front end.
0
 
rospccAuthor Commented:
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
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
yes.. try to update thru the JSP page and retriew the data and show it at the front end. This is just for testing
0
 
rospccAuthor Commented:
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.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Ok, Let me try
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.