question

NattapachSittichai-3947 avatar image
0 Votes"
NattapachSittichai-3947 asked Cathyji-msft edited

SQL Server support database collection "TIS-620" for thai language or not

SQL Server support database collection "TIS-620" for thai language or not

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NaomiNNN avatar image
1 Vote"
NaomiNNN answered

In the list of supported collations I see Thai (Thailand) 0x041e 0x041e Thai_CI_AS

https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16

Not sure if this is what you're looking for.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

This query:

SELECT collationproperty('Thai_CI_AS', 'Codepage')

tells me that the code page for Thai collations is 874.

Since I don't know Thai, and have never worked with Thai, I turned to Wikipedia. https://en.wikipedia.org/wiki/ISO/IEC_8859-11#Vendor_extensions says that CP874 differs from ISO/IEC 8859-11 only in nine symbols. (Which symbols are depicted in the article). I also read about TIS-620 and learnt that "A nearly identical version of TIS-620 has been adopted as ISO/IEC 8859-11 in 2001, the sole difference being that ISO/IEC 8859-11 defines hex A0 as a non-breaking space, while TIS-620 leaves it undefined but reserved."

So the answer to the question seem to be, yes, but not with 100% fidelity.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @NattapachSittichai-3947,

Quote from one third blog About the Thai code page and collations;

The Thai language is supported by code page TIS 620-2533.

But I am not sure that it is suitable for MS SQL server.

For collation supported in MS SQL server, suggest you reading the MS document Server-level collations that MaomiNN offered.
206470-screenshot-2022-05-30-111124.jpg


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.