How to ignore the DB_LOCALE setting

Posted in 2004

Philip Yeh — Mon, 3 May 2004 16:15:23 +0800 — source: Usenet: comp.databases.informix

Hello All, I have a special requirement. Our customer use the informix with DB_LOCALE and SERVER_LOCALE set to en_US.8859-1, but store the chinese Big5 code data. Because if they set the DB_LOCALE to zh_TW.Big5, some Big5 code cannot save into the DB. The LOCALE en_US.8895-1 don't check any codeset, so the extend Big5 code can store into the DB. But the user want to use the zh_TW.Big5 to connect to the DB Server and open the en_US.8859-1 LOCALE database. Does anybody know how to bypass the DB_LOCALE? I want to use the different CLIENT_LOCALE to connect to the Informix DB Server. Best Regards. Philip Yeh.