The default character set is the one in which data is encoded and stored on the Adaptive
Server databases.
Change 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, time-consuming steps.
To change the character set or sort order after you have added data,
see the System Administration Guide: Volume 1.
After srvbuild configures a new Adaptive Server, you are asked whether to
localize your Adaptive Server to a language other than us_english
and whether to use a character set or sort order other than the
default.
The default Adaptive Server uses:
Valid language options depend on the language modules that were unloaded from the distribution
media onto your system.
By default, all character sets are copied from the distribution media.
You can:
Click No to accept the defaults.
Click Yes to change the defaults.
You see sqlloc menu, which 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.
By default, when Adaptive Server and Backup Server are installed on HP systems, the installation
installs the character set files for Roman8, which supports the
Western European languages.
Change the Default Character Set for Servers
You can select any character set as the default on Adaptive Server, including character sets that
are not the platform default character sets. Keep these guidelines
in mind when selecting a new default character set:
-
To avoid conversion errors or overhead, determine
the default character set based on the character
set used by your clients.
For example, if most of your clients use ISO
8859-1, you can minimize the amount of data
conversion by specifying ISO 8859-1.
-
If your server is operating in a heterogeneous
language environment, choose a character set that
works with all the character sets needed. Often,
this is Unicode (UTF-8).
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 can cause
incorrect behavior. To change the character set or sort order after
you have added data, see the System Administration Guide:
Volume 1.