Foreign Language Support - Traditional Chinese

We have a customer that wants to be able to store a few of their text data fields (like a part description) in Traditional Chinese. The application will use Four J's BDL (or Genero) windows client, and the Informix SE database (IDS-Workgroup could be substituted if necessary). They want the application to run in English. Only 2 or 3 fields will be Chinese. This will be the Windows Client with Four J's. I know how to key in the Chinese characters into the Four J's Windows client, but not how to get it to process them . What I need to know is: - can I implement GLS and key English into most of the fields and Chinese into just a few? - How do I enable Four J's BDL, and the Informix database to accept and store the Chinese characters? (Is this just a matter of setting the 'LOCALE' variables?)

The traditional Chinese, zh_tw.big5 charset has English ASCII as its subset. So you should do fine, just by setting DB_LOCALE, CLIENT_LOCALE to zh_tw.big5. Make sure to set these variables, *before* creating the db. Another point to note is CHAR(n) datatype deals with bytes, and not characters. Since traditional Chinese is multi-byte charset - you might need to alter the column sizes accordingly.