Podderzhka NLS v Informix 7.*
Vopros: Prosten'kaya komanda na SQL s russkimi bukvami vnutri vyzyvaet oshibku.
select * from tbl1 where abc = "poisk" ;
Syntacksys error ----------------^
Starye vremena, kogda Informix bez dopolnitel'nyh
napominanij obhodilsya s sovetskim vos'mym bitom po chelovecheski
kanuli v proshloe. Teper' on ne shagu ni stupit bez vzvedennyh
peremennyh okruzheniya, svyazannyh s kategoriej locale, i chem
bol'she versiya, tem bol'she emu peremenyh nuzhno.
Primer dlya HP-UX Informix 7.2
From: Dennis Svinarchuck
Baza iznachal'no dolzhna byt' sozdana s fiksirovannymi LOCALE
i tol'ko s nimi potom budet rabotat'.
#
# Informix 7.2 for HP-UX10.10 server config file
#
INFORMIXDIR=/usr/informix export INFORMIXDIR
PATH=$PATH:$INFORMIXDIR/bin export PATH
ONCONFIG=onconfig.gorilla export ONCONFIG
INFORMIXSERVER=gorilla_online export INFORMIXSERVER
INFORMIXTERM=termcap export INFORMIXTERM
#
#---- LOCALES and LANG---------
#
#export DBNLS=2
LANG=ru_RU.iso88595 export LANG
DBLANG=$INFORMIXDIR/msg/en_us export DBLANG
DB_LOCALE=ru_ru.8859-5 export DB_LOCALE
CLIENT_LOCALE=ru_ru.8859-5 export CLIENT_LOCALE
SERVER_LOCALE=ru_ru.8859-5 export SERVER_LOCALE
CC8BITLEVEL=3 export CC8BITLEVEL
GLS8BITFSYS=1 export GLS8BITFSYS
ESQLMF=0 export ESQLMF
Last-modified: Sun, 27 Jul 1997 19:54:51 GMT