Hi.
I am using MS Query to retrieve data into Excel from an Oracle database. The data contains several different characters (such as degree and diameter symbols) which are stored as Unicode, but the query returns the same character for all of them.
In the MS Query window the special characters appear as upside down question marks; in Excel they show as white question marks in a black diamond. The ASCII code of the character displayed in Excel is '63', and the UNICODE() value is 65533. This isn't the character that is stored in the Oracle database.
Is there a way to correctly retrieve these characters?
The ODBC driver is Oracle in OraClient11g_home1, version 11.02.00.01. I've tried it with the 'Force SQL_WCHAR Support' setting on, but it didn't make a difference. So, I've pretty much exhausted my knowledge now...
Thanks in advance, Steve