Language problem

Posted in 1999

Koen Van Oost — Wed, 24 Nov 1999 23:09:08 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi Everyone, currently I am working on a project where we have an informix online server 7.30 running on a Windows NT and where an informix online server 7.30 runs on a unix as client. We did the installation using the language us_en (english), but since the customer is in Belgium we need to be able to insert text in our database containing characters such as ', ', ... When I do an insert in a table with a text value containing one of these characters, I get an error and the insert fails. Could somebody tell me how one can adds the language for Belgium or any other language to the installation, on NT and on Unix! Thanks, Koen Van Oost

↪ replying to Koen Van Oost

Volker Fraenkle — Thu, 25 Nov 1999 08:57:09 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi Koen, Koen Van Oost wrote: > We did the installation using the language us_en (english), but since the > customer is in Belgium we need to be able to insert text in our database > containing characters such as è, é, ... > > When I do an insert in a table with a text value containing one of these > characters, I get an error and the insert fails. What charset do you use (Windows NT, Informix)? What are the environment settings (DB_LOCALE, CLIENT_LOCALE, DBNLS)? What errors do occur? Send an example of your insert statement, please. Yours, Volker

↪ replying to Koen Van Oost

benhen7953@my-deja.com — Sun, 28 Nov 1999 20:46:11 GMT — source: Informix-list mailing list archive (1991-1998)

Hello, In Luxembourg, we use fr_ch for a mix of french and german. For Belgium, you could try fr_be ? Example : our Unix environment variables : CLIENT_LOCALE=fr_ch.8859-1 DB_LOCALE=fr_ch.8859-1 SERVER_LOCALE=fr_ch.8859-1 Ben In article <81hnkj$8tr$1@trex.antw.online.be>, "Koen Van Oost" <koen.vanoost@glo.be> wrote: > Hi Everyone, > > currently I am working on a project where we have an informix online server > 7.30 running on a Windows NT and where an informix online server 7.30 runs > on a unix as client. > > We did the installation using the language us_en (english), but since the > customer is in Belgium we need to be able to insert text in our database > containing characters such as ', ', ... > > When I do an insert in a table with a text value containing one of these > characters, I get an error and the insert fails. > > Could somebody tell me how one can adds the language for Belgium or any > other language to the installation, on NT and on Unix! > > Thanks, > > Koen Van Oost > > Sent via Deja.com http://www.deja.com/ Before you buy.