>(This is probably the wrong place to ask this question. If someone would like to suggest a better place, I'm listening.)
>
>I access an Oracle database with SQLEXEC. One of my VARCHAR2 fields is encrypted and uses all characters from x01 to xFF. No problem in Oracle 8. I try to install on Oracle 9, and from my machine (with Oracle 8 client) it works fine. But when accessing the same database on a machine with Oracle 9, some of the characters are transated to "¿". I tried both the Microsoft and the Oracle ODBC drivers. When I read the connect string with SQLGETPROP() it shows me TLO=0 (or is it O?) in both cases.
>
>I imagine that this is configurable somewhere. Does anyone know where and how to turn off what seems like code page translation?
You could join a listserver at
www.lazydba.com.
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!