Posted by kenneth.osenbroch on 03/07/06 11:16

Hi,

I have a MSSQL Server communicating with an Oracle database through a
MSSQL linked server using a MS ODBC connection.

If I query the Oracle database through the Oracle ODBC 32Bit Test, the
result is fine:

select addrsurname from address where addrnr = 6666;
HÅKANSSON

If I do the same query within the SQL Query Analyzer (using the linked
server), I get:

select * from openquery(TESTSW, 'select addrsurname from address where
addrnr = 6666');
HKANSSON

I have tried to both check and uncheck the Automatic ANSI to OEM
conversion, but the result remains the same.

Does anyone know what to do to make the result display the special
characters in SQL Query Analyzer?


Thanks,
Kenneth

• Next in forum: Re: ORDER BY in VIEW not working
• Prev in forum: Re: ORDER BY in VIEW not working
• Thread view: Special characters in MSSQL.

[Reply to this message]