Re: Foreign language support in Informix Online

andy lennard (andy@kontron.demon.co.uk) wrote: : > Is it possible to develope a "Chinese" database application using : > Informix Online running in a Unix environment? Only the input screen : > and printed report has to be in Chinese. How about using a front-end : > tool that can support foreign languages? However some fields in the : > tables has to store Chinese characters as well. : I think it's ok in V7. We are about to try this, but not with : Chinese, and from what I recall of the manual I read, there are : additional data types of nl_char and nl_varchar (may be wrong : names..) which can accept 'extended' character sets, or sets which do : not use the ascii order for sorting. NLS support, with NCHAR and NVARCHAR datatypes, does not support multi-byte character sets, such as those required by Chinese. It supports 8-bit ASCII, with language-defined collation sequences. What is needed to store multi-byte character sets, such as Chinese, is either GLS (Global Language Support), supported starting in 7.20, or ALS (Asian Language Support), special ports available on pre-7.20 products. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.