SQL Server support database collection "TIS-620" for thai language or not
In the list of supported collations I see Thai (Thailand) 0x041e 0x041e Thai_CI_AS
Not sure if this is what you're looking for.
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.
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".
24 people are following this question.