• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 497
  • Last Modified:

Store Thai and Korean Characters

Hi,

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

Regards,
rospcc
0
rospcc
Asked:
rospcc
  • 7
  • 4
  • 2
2 Solutions
 
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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 7
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now