Re: non-English alphabet trouble

Harald Hedlund wrote: > > I always get the error > > Last week I posted the same question, and I got a lot of sensible > feedback. But it still won't work. I've set the DB_LOCALE, > CLIENT_LOCALE to proper value i.e. sv_se.8859-1 and exportet them > in the start-up script for the informix server. I have also set the same > variables for the database creator. I have tried to create databases > thorugh dbaccess and also through a c-shell script that calls upon > dbaccess but neither works. > > What is it that I must do to get this problem straighted out? > > I use informix version 7.12 -> could that be the problem? > > Also, what is Nls? None of my databases support it so I'm quite > curious what it is. > > //Harald Hedlund (ae95hhe@csd.uu.se) Hi, If you are using Online 7.1x you have NLS features. You are enabled to use language specific files i.e. code pages coming with your operating system. Beacuse of this it is called National Language Support. If you have Online 7.2x you can use any language that Informix has related files in its GLS directory although your system does not support them which is called Global L. S. Returning to your case since you have NLS enabled database you should set the env. var.'s below: LC_COLLATE LANG LC_CTYPE all of three are set to "se_se..." DBNLS is set 1 -> users can connect the databases that have the NLS settings are the same with the env. var.'s above OR 2 -> users can connect any of the databases since env. settings are got from the database itself. (most suitable) I hope this would help :) -- Ozlem Atmaca Tel: +90 216 3275003 Technical Support Engineer Fax: +90 216 3264882 Login Bilgisayar A.S Istanbul/Turkey