validating locale of a DB
Posted in 2010
Topics: Internationalization & Character Sets
Does anyone know the table where one can determine the locale a database was created with .. Thanks in advance ... v11.50.fc7 Aix 6.1 Peter Logan Senior Database Administrator Phone: 616/878-8309
in sysmaster. sysdbslocale regards andy g. > To: ids@iiug.org > From: Peter_Logan@spartanstores.com > Subject: validating locale of a DB [22156] > Date: Wed, 8 Dec 2010 10:18:51 -0500 > > Does anyone know the table where one can determine the locale a database > was created with .. Thanks in advance ... > > v11.50.fc7 > Aix 6.1 > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
SELECT * FROM sysmaster:sysdbslocale WHERE dbs_dbsname = 'mydatabase';
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Wed, Dec 8, 2010 at 10:18 AM, Peter_Logan@spartanstores.com <
Peter_Logan@spartanstores.com> wrote:
> Does anyone know the table where one can determine the locale a database
> was created with .. Thanks in advance ...
>
> v11.50.fc7
> Aix 6.1
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf3054ace3511ae70496e87d2e