Re: Informix-Locale on Windows-NT

Andreas Stolle wrote: > = > We'v got Informix-Workgroup-Server 7.22 on Windows-NT 4.0. > = > After installing the Software correctly we've got the following Problem= : > = > insert into test values ("a=E4u")> = > Results into error: -202 An illegal character has been found in the > statement. > = > We've been told to set the following variables (by ifx-hotline): > = > CLIENT_LOCALE=3DEN_US.CP1252 > DB_LOCALE=3DEN_US.8859-1> DBLANG=3DEN_US.CP1252 > = > I've tried to set this values using setnet32 and DOS-Prompt "set"-Comma= nd. > But nothing happens. I've still error -202 > = > What could i do ? > = > MFG > Andreas Stolle > Mail: Stolle@sog.de Hello, We have also the same problem with Turkish char.'s If you don't need to sort char. fields according to use your alphabet order I can say that you should set the environment var.'s as = CLIENT_LOCALE=3Den_us.1252@dict DB_LOCALE=3Den_us.1252@dictDBLANG=3Den_us.1252@dict For the tools run on Windows like Database Explorer the values of those are got from registry set via SETNET utility, for DBACCESS they are got from system environment. If you also want to sort according to your language you should use the locales of your own like de_de??? found in $INFORMIXDIR\\gls\\lc11. Hoping this would help... -- = Ozlem Atmaca Tel: +90 216 3275003 Technical Support Engineer Fax: +90 216 3264882 Login Bilgisayar A.S Istanbul/Turkey