Collating Thai characters

Thai contains special vowels ("leading vowels"), tonal marks and other special characters that are not sorted sequentially.

About this task

You must either create your database with a Thai locale and code set, or create a Unicode database.


  • To create a database using Thai and the corresponding code set, use the COLLATE USING NLSCHAR clause of the CREATE DATABASE command.
  • To create a Unicode database, use the COLLATE USING locale-sensitive-collation clause of the CREATE DATABASE command and specify a Thai locale attribute, such as CLDR181_LTH.