Re: Finding DB_LOCALE of database
>From: nguyenv@cognos.com (Vinhson)
>Date: 31 Jul 1997 18:15:42 GMT
>X-Informix-List-Id: <news.41078>
>
>Within an ESQL/C client application, I would like to find
>the setting of the database locale stored in the system
>catalog of the database that my application has attached to.
>Does anyone know how I could do that?
SELECT TabName, Site FROM SysTables WHERE TabName LIKE ' GL_%';
On my databases, that returns two rows:
GL_COLLATE|en_US.819
GL_CTYPE|en_US.819
I don't know under what circumstances the entries produce different
answers. There may also be other, less protracted ways of dealing
with it too which I am unaware of.
Yours,
Jonathan Leffler (johnl@informix.com) #include <witticism.h>