
SPECIFYING LANGUAGE, CHARACTER SET, AND SORT ORDER

This screen displays the current default settings for the 
Adaptive Server you specified. 

WARNING!  Make all changes to the 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 can have major implications 
for the data and for any client applications that access the data.

For more information about the implications of changing character 
sets and sort orders, see the Adaptive Server System Administration
Guide. 

To change a default setting: 

1. Select a value from the list. 
2. Click OK when you are done.
3. If you want to return to the original settings, click Reset.

THINGS TO CONSIDER:

Language: 
The list contains all languages installed in the $SYBASE/locales 
directory. To use a language that is not listed, you must first install 
it on your system.

Character Set:
The list contains all character sets that are compatible with the default 
language you selected. As you change the setting for the default language, 
the list of character sets changes accordingly.
   
Sort Order:
The list contains all sort orders that are compatible with the default 
character set you selected. As you change the setting for the default character 
set, the list of sort orders changes accordingly.

After changing the sort order for an Adaptive Server, take 
the following steps to fix any invalid indexes that may result: 

 1. Run sp_indsuspect to find user indexes that may no longer be valid. 
 2. Rebuild suspect user indexes, using the dbcc reindex command. 

