database locale information mismatch
Dirk Gunsthoevel got error -23197, database locale information mismatch, selecting from a table in one database while connected to another created with a different DB_LOCALE (default versus de_DE.1252). RW's advice to set DB_LOCALE per database did not help, since the error arises in cross-database queries. Thomas Parsli called it by design and pointed to the GLS guide. No workaround given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi *.* On one of my servers I have two databases (lets say dba and dbb) cretated using different DB_LOCALEs (default and de_DE.1252). When I use use dba and then do: select <whatever> from dbb:sometable I get error -23197: database locale information mismatch. Is there any way around this? Regards, Dirk -- -- Dirk Gunsthoevel phone: +49 (0)251 624947 -- Hoeftestr.49 fax: +49 (0)251 624177 -- 48167 Muenster mobile: +49 (0)170 5464715 -- Germany http://www.killerbunny.de
>On one of my servers I have two databases (lets say dba and dbb) >cretated using different DB_LOCALEs (default and de_DE.1252). >When I use use dba and then do: > select <whatever> from dbb:sometable >I get error -23197: database locale information mismatch. You need DB_LOCALE to be appropriate to database you want to access. If you had created dbb database using de_de.1252 you must set DB_LOCALE to de_de.1252 otherwise you may encounter problems - or even get error. By the way - Is it possible to use nchar data type in 4gl programs? I have different client terminals: pl_pl.mazovia and pl_pl.8859-2 and I need my 4gl program to display nchars on both terminals. RW
RW wrote:
>
> >On one of my servers I have two databases (lets say dba and dbb)
> >cretated using different DB_LOCALEs (default and de_DE.1252).
> >When I use use dba and then do:
> > select <whatever> from dbb:sometable
> >I get error -23197: database locale information mismatch.
>
> You need DB_LOCALE to be appropriate to database you want to access. If you
> had created dbb database using de_de.1252 you must set DB_LOCALE to
> de_de.1252 otherwise you may encounter problems - or even get error.
>
Hi again :>
Thank you for your answer but this wont help. My problem
isnt to connect to the two databases individually
(lets say with dbaccess). The error only occurs when
I am connected to one of the databases and do a select
on tables in the other one.
Take care
Dirk
Dirk Gunsthoevel <gunstho@uni-muenster.de> writes: > Hi *.* > > On one of my servers I have two databases (lets say dba and dbb) > cretated using different DB_LOCALEs (default and de_DE.1252). > When I use use dba and then do: > select <whatever> from dbb:sometable > I get error -23197: database locale information mismatch. > > Is there any way around this? Just another feature, or "... by design" to use a Microsoft term. Check out "Informix Guide to GLS Functionality" at Answers OnLine. Thomas