Enter the following command to view the character sets and sort orders that are currently available in your Adaptive Server:
1> select id, csid, name, description from master..syscharsets 2> go
In the output:
When csid = 0, the value of id represents the character set ID
When csid = the character set ID (something other than 0), the value of id represents the sort order ID
For example:
1> select id, csid, name, description from master..syscharsets 2> go
id csid name description --- ---- ---------- -------------------------------------------- 0 0 ascii_8 ASCII-8 - 7-bit ASCII, with implementation- defined characters for values 128-255. 1 0 iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set. 50 1 bin_iso_1 Binary sort order for the ISO 8859/1 character set (iso_1).
In the example:
For character set ascii_8, the character set ID is 0
For character set iso_1, the character set ID is 1
For sort order bin_iso_1, the character set ID is 1 and the sort order ID is 50
