Even after you have configured your server, a System Administrator can change the default character set, sort order, or message language used by Adaptive Server. Because a sort order is built on a specific character set, changing character sets always involves a change in sort order. However, you can change the sort order without changing character sets, because more than one sort order may be available for a character set.
To display Adaptive Server’s default sort order, character set, and a table of its primary sort orders, enter:
sp_helpsort