ASA Database Administration Guide
International Languages and Character Sets
Collation internals
The first non-comment line must be of the form:
Collation collation_label (collation_name) (ase_charset) (ase_so_sensitive) (ase_so_insensitive) (java_charset)
Argument | Description |
---|---|
Collation | A required keyword. |
collation_label | The collation label, which appears in the system tables as SYS.SYSCOLLATION.collation_label and SYS.SYSINFO.default_collation. The label must contain no more than 10 characters. |
collation_name | A text description of the collation, usually describing the character set and ordering of the collation. |
ase_charset | The ASE name of a character set matching the character set of this collation. This name is used to make character set mappings when server character set translation is enabled (the default). |
ase_so_sensitive | The name of an Open Client or ASE case sensitive collation matching this collation. |
ase_so_insensitive | The name of an Open Client or ASE case insensitive collation matching this collation. |
java_charset | The name of a Java character set matching the character set of this collation. This name is used when converting character data between the Java virtual machine and the database. |
For example, the 932JPN collation file contains the following collation line, with label 932JPN and name (Code Page 932, Japanese Shift-JIS with Microsoft extensions):
Collation 932JPN (Code Page 932, Japanese Shift-JIS with Microsoft extensions) (cp932) (bin_cp932) (bin_cp932) (SJIS)