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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:
Yes, you can store data in two differrent nvarchar columns

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
J2811Commented:
I think setup your database collation/encoding as unicode, then can store any language, well almost.

Hope this helps.

Regards,
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
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

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
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.
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)

Aneesh RetnakaranDatabase AdministratorCommented:
try to update it from the front end.
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
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
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.
Aneesh RetnakaranDatabase AdministratorCommented:
Ok, Let me try
Aneesh RetnakaranDatabase AdministratorCommented:
Aneesh RetnakaranDatabase AdministratorCommented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.