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