Re: creating databases with GLS ??

Posted in 1998

Jacques P Renaut — Wed, 23 Dec 1998 14:05:26 -0600 — source: Informix-list mailing list archive (1991-1998)

Well, I'll not claim to be any GLS expert, but what you did should be all you need to do. I played around with it a bit and discovered the following, on solaris anyway (on 7.24 and 7.30). Like you when I used the en_us.8859-1 setting for DB_LOCALE and CLIENT_LOCALE in the system catalogs I got the name to be en_US.819. However, if I check the glfiles executable and look in the lc11.txt file there is no locale named en_US.819. I then experimented further by picking to german locales from the lc11.txt file. The first I used was de_at.8859-1 and when I looked in systables it was now de_AT.819. I then tried de_at.CP1252, and in systables it was just de_AT.1252. So it appears that the value stored in the site column of tabid 90 or 91 is not the literal value of DB_LOCALE, at least on sun. I'm not sure why this is, from the other post it looks like on AIX it is the literal value. Perhaps HP is like sun and doesn't store the literal locale name. I do know that once a database/table is created with a particule locale the only way to change it is to drop it and recreate it. Jerry A. Van Zant wrote: > First off the system > > Online 7.24.UC6 > HP/UX 10.10 > > When I create a database either with dbaccess or dbimport, it looks > like the system is ignoring the environment variables. I have the > following set: > > DB_LOCALE=en_us.8859-1 > CLIENT_LOCALE=en_us.8859-1> > But the database is created with en_us.819. > (systables where tabid = 90 and 91) > > This leads to two questions > 1) Why is it ignoring the environmental variables? > 2) How do I change it from en_us.819 to en_us.8859-1? > > Thanks > Jerry > > PS: I called Informix about this and it was like talking to a rock. > So much for direct to the engineer! -- ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************