Re: GLS and I-sql

Stephane Magnan wrote: > > Hi all, > > I'm a new Informix DBA and I have some problem to understand GLS. > > We have ONLINE 7.20 on SunSolaris. > > I'd like to insert in my databases some data with accent characters. > > I created a database (by default) without set the variables concerning > GLS and when I use Isql (QueryLanguage) I cannot insert one row with > the accent characters BUT when I insert with Isql (Form) I can insert > one row with the accents !!!! > > After I created a database with set the DB_LOCALE=fr_fr.8859-1 and > there I can insert some accent characters using Isql (QueryLanguage). > > Other things, we have MS-Access and with this tool I can insert some > accent characters without problem in one database (through openlink) > created simply (by default). > > Could you tell me if I-Net can give some problem with GLS ? > We use I-NET for Windows 5.01. > > Could we change the code set after the creation of a database (from > default to another code set) or must we delete the database and > recreate it again ? > > Thanks in advance for your information about GLS. > > Stephane > Switzerland Hi Stephane ! I have no explanation for your isql problem. Concerning MS-Access, I have detected, that CLIENT_LOCALE is only used for PassThrough-SQLs. SQLs executed by the jet engine take the current windows environment, if no format is specified. I do not know if there is a possibility in I-Net 5.01 to set a value for CLIENT_LOCALE. Probably not. If CLIENT_LOCALE is not set the default (en_us.8859-1) is taken. We use Informix-Connect 7.20.TE1 (successor of I-Net, just a new name) which gives you the possiblity to set the LOCALE's. The values are stored in the registry under HKEY_CURRENT_USER/Software/Informix/Environment. Perhaps it helps if you set the variables manually for I-Net 5.01. You can not change the GLS environment of a database. You have to drop and recreate it. To be sure that the new DB_LOCALE setting becomes active you have to shut down and restart Informix. The current GLS environment of a database is stored in the systables. The following SELECT shows you the current setting: SELECT site FROM systables WHERE tabname = ' GL_COLLATE' Hope this helps ! Tschuess, Dirk -- --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmidtpott.pad@sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-27905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------