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

Question

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

Answer 1

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

https://learn.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.

Answer 2

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.

Answer 3

Hi @Nattapach Sittichai ,

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.

---

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