RE: Multi-language data in a database

We don't use it. We just upgraded from version 5 to version 7.3 2 months ago. Best regards, Doris -----Original Message----- From: Octav Chiriac [mailto:com@netinfo-moldova.com] Sent: woensdag 8 september 1999 11:22 To: Willaert Doris Cc: informix-list@iiug.org Subject: 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