User's Manual

Chapter 6. Principles of SQL Remote Design
4. Make the database case sensitive You can do this with the dbinit -c
option.
The following command creates a case-sensitive database named test.db in
the current directory, using the current dbo user, ignoring trailing blanks,
and removing historical system views:
dbinit -b -c -k test.db
Using compatible sort orders and character sets
The SQL Remote Message Agent does not perform any character set
conversions.
Character sets in
Adaptive Server
Anywhere installations
For an Adaptive Server Anywhere installation, the character set and
collation used by the consolidated database must be the same as the remote
databases. For information about supported character sets, see “International
Languages and Character Sets” [ASA Database Administration Guide, page 319].
Character sets in
Adaptive Server
Enterprise installations
The Open Client/Open Server libraries perform character set conversions
between SSREMOTE and Adaptive Server Enterprise whenever the
LOCALES.DAT character set is different from the Adaptive Server
Enterprise character set. Both character sets must be installed on the
Adaptive Server Enterprise server and conversion must be supported.
Character sets in mixed
installations
The locales.dat settings (which are used by all Open Client applications)
must match the remote Adaptive Server Anywhere settings.
The following table provides recommended matches between Adaptive
Server Enterprise and Adaptive Server Anywhere character sets. The
matches are not all complete.
Adaptive Server
Anywhere colla-
tion name
Open Client /
Open Server
name
Open Client /
Open Server case-
sensitive sort order
Open Client
/ Open
Server case-
insensitive
sort order
default cp850 dictionary_cp850 nocase_cp850
437LATIN1 cp437 dictionary_cp437 nocase_cp437
437ESP cp437 espdict_cp437 espnocs_cp437
437SVE cp437 bin_cp437 bin_cp437
819CYR iso_1 bin_iso_1 bin_iso_1
819DAN iso_1 bin_iso_1 bin_iso_1
75