Use one of the following commands to load a sort order or an additional character set into syscharsets:
Operating System |
Command |
---|---|
UNIX |
$SYBASE/$SYBASE_ASE/bin/charset -P sa_pwd -S server_name sort_filechar_set or $SYBASE/$SYBASE_ASE/bin/charset ... in 12.0 and later |
Digital OpenVMS |
charset /pass="sa_pwd" - /server="server_name" sort_file - /local=sybase_system:[sybase.charsets.char_set] |
Novell NetWare |
load $SYBASE/$SYBASE_ASE/bin/charset -Psa_pwd -Sserver_name sort_filechar_set or load $SYBASE/$SYBASE_ASE/bin/charset ... in 12.0 and later |
OS/2, Windows NT |
$SYBASE/$SYBASE_ASE/bin/charset -Psa_pwd -Sserver_name sort_filechar_setor $SYBASE/$SYBASE_ASE/bin/charset ... in 12.0 and later |
where:
sa_pwd is the “sa” password
server_name is the name of the Adaptive Server
sort_file is the appropriate sort order name from the charsets directory; to load a character set, use “charset.loc” for the value for sort_file
char_set is the name of the character set you are loading
For example, to load the case-insensitive sort order for character set iso_1 on UNIX, the command is:
% $SYBASE/$SYBASE_ASE/bin/charset -Psa_pwd -Sserver_name nocase.srt iso_1
For example, to load the cp850 character set on OpenVMS, the command is:
$ charset /pass="sa_pwd" - /server="server_name" charset.loc - /local=sybase_system:[sybase.charsets.cp850]