Re: Multi-language data in a database

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