Charset problem when using SQL statements with ODBC

Hello,

I configured an ODBC application with an ORACLE 8.1.7 server on the server installation. The application has a basic installation procedure which executes direct SQL statements like "INSERT INTO". There UNICODE-symbols such as the European currency symbol "?" are inserted. Unfortunately the "?" is being translated into a Spanish symbol "¿" (ASCII 0191). Later the application commences these INSERTS and of course this causes severe problems. When the application uses an ADODB/ODBC recordset to update data the "?" is inserted correctly, thus the database itself is capable of keeping UNICODE data. It seems that a sort of character translation is only commited to direct executes of INSERT or UPDATE statements.

Does anyone know how to turn off the character translation?

Regards,
Stefan Mueller Received on Fri Apr 19 2002 - 17:44:00 CDT