|
From: Peter <L....@pf...> - 2005-12-22 10:00:05
|
Hi, I am using Squirrel together with Informix 9.30.FC2 and use the Informix driver v.3.0 JC3 One guy managed to set up a DB with a DB_LOCALE of codepage 850, but didn't set up the DB correctly, that is the DB has an "official" DB_LOCALE of 819 (which is Latin-1 aka CP1252 aka ISO 8859-1). There is currently no easy way to switch the codepage of the DB because of some applications running well with this strange configuration. I can set up the ODBC driver with a codeset conversion from DB_LOCALE = en_US.850 to a CLIENT_LOCALE = en_US.CP1252 and e.g. the Umlauts are correctly transformed during a SquirrelSQL query. But I would rather use the Informix driver to retrieve more information from the DB (e.g. the catalogs are not listed in the Objects-tab of Squirrel) But I can't get the codeset conversion to run with the Informix driver. It should work like this: jdbc:informix-sqli://server:port/dbname:INFORMIXSERVER=servername;CLIENT_LOCALE=en_US.CP1252;DB_LOCALE=en_US.850;IFX_CODESETLOB=4096 but it doesn't. There's no complaint about unsupported language or whatsoever (try e.g. DB_LOCALE=en_US.80 to get the error message) It simply doesn't convert the stuff. Is there someone out there, who has already solved this problem? TIA! cu Peter |
