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