Charset problem when using SQL statements with ODBC

[Quoted] 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 "?" [Quoted] 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 [Quoted] commited to direct executes of INSERT or UPDATE statements.

Does anyone know how to turn off the character translation?

Regards,
Stefan Mueller Received on Sat Apr 20 2002 - 00:44:00 CEST