We have a problem with ODBC driver interpreting data type differently on SQL Server 2012 linked to Oracle 220.127.116.11 unicode database.
SQL DB 2012 server - Windows 2012 server
Oracle database server - Windows 2016, Oracle database 18.104.22.168 Unicode database
Installed Linked server - using Oracle 22.214.171.124 client/ODAC and ORAOLEDB.ORACLE provider
Using osql to run odbc trace, found that the data type being used for column is -9 which is WVARCHAR. Unfortunately our application does not support wvarchar so it has to be VARCHAR. Is there a way to make ODBC interpret the column as varchar instead of WVARCHAR?
osql -S server c88-798 EXIT SQLDescribeColW with return code 0 (SQL_SUCCESS)
WCHAR * 0x0000000000000000 <null pointer>
SWORD * 0x00000000009DD870 (8)
SWORD * 0x00000000009DD874 (-9)
Appreciate all your suggestions in advance. Thank you