Re: Problems Connect NT-Clients to NLS-DBs (Locales)

Hi Guenther, Guenther Schmid wrote: > > Hi, > > On our 7.31-Server (Solaris 2.6) we have a lot of > NLS-Databases with the Database Locale set to "de". > When we try to connect to these databases using > NT-Clients we get the error message "Code sets of > the local categories are not the same" (I already > tried setting CLIENT_LOCALE etc., didn't get it) > - it happens with CLI 2.8, IECC, Informix SQL-Editor, > but works fine with CLI 2.5 ! > We don't have these problems with NLS-Databases having > the Locale set to, for example, "de_DE.819". > > 1) What are we doing wrong ? Check your DBNLS variable. I suppose, it is set to 1. This mean, your clients DB_LOCALE must have the same value as the value stored in your database. > 2) Is there an easy way to change the Database Locale ? No, you have to export an import your database. > 3) Will we run into problems when changing the Locale ? > 4) Should we migrate to GLS ? Does this make problems ? Try set DBNLS to 2. This will solve your problems. The answers for questions 3 and 4 depend on your local environment. I don't know much about that. Yours Volker