When the database uses a non-default locale for your platform, you must
set an environment variable on the local client for SAP Sybase IQ to
load the correct information for language, collation sequence, character set, and date/time
format.
When determining the locale name, SAP Sybase IQ first checks
for the value of the LC_ALL environment variable. If LC_ALL is not set,
SAP Sybase IQ uses the value of the LANG environment
variable. If neither variable is set, SAP Sybase IQ uses the
“default” entry in the locales file.
- In a text editor, open the $SYBASE/locales/locales.dat
file.
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
set the value of the environment variable LC_ALL or LANG to “american.iso88591”.
Otherwise, SAP Sybase IQ uses the locale name “default”
which has collation “roman8”.
For example, in the sh or ksh shells,
enter:
LC_ALL= american.iso88591;export LC_ALL
In the csh or tsch shell,
enter:
setenv LC_ALL american.iso88591