Re: Multi-language data in a database
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, 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