Sort orders

Each character set comes with one or more sort orders (collating sequences), which are located in the sort-order definition files (.srt files). These files accompany the character-set definition files and can be found in the same directory.

You can select a sort order for your data according to the needs at your site. Keep in mind that the server can support only one sort order at a time, so select a sort order that will work for all of your clients.

WARNING! Make all changes to the default character set and sort order for a new Adaptive Server before creating any user databases or making any changes to the Sybase-supplied databases. Changing the character set and sort order after data or data structures have been added to Adaptive Server may cause incorrect behavior. To change the character set or sort order after you have added data, see the System Administration Guide.