Thai Language Support

Sybase IQ provides the CP874toUTF8 utility to convert data files in CP874 format into UTF8, a collation supported by Sybase IQ for the Thai language.

For syntax, see the Utility Guide. You can also load data in the CP874 character set without converting it to UTF8 using this utility.

The SORTKEY() function returns values in the sort order thaidict (Thai dictionary), the Thai character set in UTF8 form. For syntax see Reference: Building Blocks, Tables, and Procedures. The following statements generate the same result:

SELECT c1, SORTKEY(c1) from T1 where rid=3
SELECT c1, SORTKEY(c1, ‘thaidict’) from T1 where rid=3)
SELECT ‘\340\270\201\340\271\207’,SORTKEY(‘\340\279\201\340\271\207’) from T1 where rid=3