Sybase DC35823-01-1500-04 Server User Manual


 
CHAPTER 7 Customizing Localization for Adaptive Server
Configuration Guide 83
Default character sets for servers
The default character set is the character set in which data is encoded and stored
on the Adaptive Server databases.
Changing the default language and character set
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 may require
additional steps. To change the character set or sort order after you have added
data, see the System Administration Guide.
After
srvbuild configures a new Adaptive Server, it displays a message box
asking if you want to localize your Adaptive Server to a language other than
us_english and if you want to use a character set or sort order other than the
default.
srvbuild creates an Adaptive Server with the following defaults:
us_english language
iso_1 character set (on HP-UX platforms, use Roman8)
Binary sort order
Valid language options depend on what language modules were unloaded from
the distribution media onto your system.
All character sets are copied from the distribution media by default.
You can:
Click No to accept the defaults.
Click Yes to change the defaults.
The
sqlloc menu is displayed. sqlloc is the GUI utility used to change
default languages, character sets, and sort orders.
By default, when Adaptive Server and Backup Server are installed on IBM,
and SUN Solaris systems, the installation installs the character set files for ISO
8859-1, which supports the Western European languages.