SAP Sybase IQ provides the CP874toUTF8 utility to convert data files in CP874 format into UTF8, which is a collation supported by SAP Sybase IQ for the Thai language.
You can also use the utility to load data in the CP874 character set without converting it to UTF8.
The SORTKEY() function returns values in the sort order thaidict (Thai dictionary), the Thai character set in UTF8 form. The following statements each 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