Re: Multi-language data in a database
No way. IDS 7.30UC2. The error message is: "Unable to load locale categories". Sorry doesn't work. What Informix server version do you have ? Does it really work ? Best Regards, Octav On Fri, Sep 17, 1999 at 11:23:27AM -0700, Heiko Giesselmann wrote: > Octav, > > starting with 7.2, connectivity products and server support reading and writing UTF-8 > characters. If you need Unicode right now you would have to convert from UTF-8 to > Unicode on the application level. Setting CLIENT_LOCALE and DB_LOCALE to (e.g.) > en_us.utf8 should work to create a UTF-8 database and manipulate UTF-8 character data. > > Hope this helps, Heiko > > Octav Chiriac wrote: > > > Sory, I have no universal server at my hand, so I'll talk just about IDS. > > My registry file contains the utf8 and unicode codes, but there are no > > locales or conversion codeset files for them. I've try looking in > > the "Guide to GLS functionality" that comes with IDS 7.3 and found > > no reference to this. Of course IDS supports multibyte characters, but > > I don't know how to set CLIENT_LOCALE, DB_LOCALE so I can work > > with a UTF-8 (or UNICODE) encoding (all I get is > > "Unable to load locale categories"). > > > > Do you know how to handle this issue in IDS ? > > > > Thank You, > > Octav > > > > On Thu, Sep 09, 1999 at 10:09:42AM -0700, Heiko Giesselmann wrote: > > > Octav, > > > > > > there is a UTF-8 locale and a Unicode datablade (which supports some special > > > Unicode datatypes). More information should be in the GLS manuals > > > (http://www.informix.com/answers). > > > > > > Heiko > > > > > > Octav Chiriac wrote: > > > > > > > It's just interesting - how do you manage different locales encodings > > > > (of course if you have to manage them, and I suppose you have to), since > > > > one database stores data just in one locale that you have set > > > > in DB_LOCALE on database creation? > > > > And there are no Unicode or UTF support in Informix. ( yet ) ? > > > > Or may be it is ? Does anybody have any information on this ? > > > > > > > > Best Regards, > > > > Octav > > > > > > > > On Wed, Sep 08, 1999 at 10:21:45AM +0200, Willaert Doris wrote: > > > > > > > > > > > > > > > Over here in Belgium we have to store certain data in at least 2 languages. > > > > > Therefore we always store the descriptions in separate tables that also > > > > > contain a language code. In function of the language code of the user of the > > > > > application (stored in an environment variable) we retrieve the description > > > > > of the item in the language of the user. > > > > > For the clients stored in the database, we also store always the language > > > > > code in the client record. When we make invoices, ... the data is always > > > > > retrieved and printed in the language of the client. > > > > > > > > > > Hope this helps. > > > > > > > > > > Doris Willaert > > > > > E-mail : doris.willaert@suzuki.be > > > > > > > > > > > > > -- > > > > Octav Chiriac Phone: (373) 2 22 99 67 > > > > NetInfo S.R.L. Fax: (373) 2 21 36 59 > > > > Chisinau (373) 2 22 84 88 > > > > Moldova, Republic of mailto:com@netinfo-moldova.com > > > > -- > > Octav Chiriac Phone: (373) 2 22 99 67 > > NetInfo S.R.L. Fax: (373) 2 21 36 59 > > Chisinau (373) 2 22 84 88 > > Moldova, Republic of mailto:com@netinfo-moldova.com -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com