Oracle90 and ODBC on WinXP, problem with non-english character

I have a problem.

Using Oracle ver.9 server on Win2K, some of varchar fields contain non-English characters (1 byte character above 128). With client on Win2K, retrieving the data via ODBC (Oracle90 driver) everything is fine. I can read and write these character properly. But when the client programs are migrated to WinXP
(with ODBC Oracle90 driver, too) some of characters are not retrieved roperly.

So far, I noticed 0xE8 and 0xC8 (è or French accent-grave in Latin-1, or C-caron in Latin-2) are both converted to 0xBF while retrieving, -- in ODBC log, it's shown as "\ff" -- and trying to write these characters to the database, 0x3F "?" character is written instead.

(So far the code that I found having problem are:

   0x8F, 0x91, 0x93, 0x96,... 0xCD, 0xCF, 0xD1, 0xD3, 0xD6...)

Exotic characters which are not used in French seems to have problems, maybe there's some hidden tip about XP's local setting, but so far I didn't find any solution.

Would anyone help me?

muchan Received on Wed Jun 26 2002 - 18:45:02 CEST