Oninit cdi / Archive
Talk to an expert →

database locale information mismatch

Posted in 1999

Topics: Server Administration, Internationalization & Character Sets

Dirk Gunsthoevel — — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Dirk Gunsthoevel
RW — — source: Informix-list mailing list archive (1991-1998)

>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

↪ replying to RW
Dirk Gunsthoevel — — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Dirk Gunsthoevel
Thomas Parsli — — source: Informix-list mailing list archive (1991-1998)

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

Related threads