When the database uses a non-default locale for your platform,
you must set an environment variable on the local client in order
for Sybase IQ to load the correct information for language, collation
sequence, character set, and date/time format.
When determining the locale name, Sybase IQ first
checks for the value of the LC_ALL environment variable.
If LC_ALL is not set, Sybase IQ uses the value of the
LANG environment variable. If neither variable is set, Sybase IQ uses
the “default” entry in the locales file.
- Open the $SYBASE/locales/locales.dat file
in a text editor.
For example:
locale = default, us_english, roman8
locale = C, us_english, roman8
locale = american, us_english, roman8
locale = english.iso88591, us_english, iso_1
- Set
the LC_ALL or LANG environment variable to the correct
value. If on the platform in step 1, your database’s collation
is iso_1 and you are using English, then you need to set
the value of the environment variable LC_ALL or LANG to “american.iso88591”.
Otherwise, Sybase IQ will use the locale name “default” which
has collation “roman8”.
For example, in the sh or ksh shells:
LC_ALL= american.iso88591;export LC_ALL
In the csh or tsch shell:
setenv LC_ALL american.iso88591