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'u")> > 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=EN_US.CP1252 > DB_LOCALE=EN_US.8859-1> DBLANG=EN_US.CP1252 > > I've tried to set this values using setnet32 and DOS-Prompt "set"-Command. > But nothing happens. I've still error -202 > > What could i do ? > > MFG > Andreas Stolle > Mail: Stolle@sog.de Hi Andreas ! I think I can help here. If you want to work in a german environment, you have to do the following things: NT Server side: To get dbaccess to work properly edit the file setenv.cmd in %INFORMIXDIR% and set DB_LOCALE=de_de.west-europe CLIENT_LOCALE=de_de.west-europe This means that from now on all databases are created as german databases. If you already have created databases and you want them to be german databases, you have to dbexport/dbimport them. You can check the current locale environment with the following SQL in the sysmaster database: SELECT * FROM sysdbslocales Client Side: In the first tabbing of Informix Connect you can set environment variables. You will find DB_LOCALE and CLIENT_LOCALE here, too. Set them like you did it on the server. With these settings you should have no problems with umlauten. By the way, if you just want to use umlaute while you keep the decimal point as ".", set the locale variables as follows: DB_LOCALE=en_gb.west-europe CLIENT_LOCALE=en_gb.west-europe This works fine (in times of the EU even the english guys have to know umlaute ;-)). For further information RTFM "Guide to GLS functionality". Hope this helps ! Tschuess, Dirk -- --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmidtpott.pad@sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-27905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------