Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reading Data from SQL Server 2000 Linked Servers

77250Apr 23 2007 — edited Apr 24 2007

Hello,

I have a colleague who wants to read data from a OO4O driver Linked Server my FRENCH_FRANCE.US7ASCII Oracle 8i database.
He's got some troubles to read data with "é", "à", and so on. They always replaced by "?"

Since I have ask him to use SQL Developer on his server to see if he has got configuration problems, his PL/SQL queries return "square figure" characters (not the usual "²") instead of "?".

For info, I've said it to use CONVERT(column, 'FR8DEC', 'US7ASCII) but it doesn't work too (also try with 'UTF8' or 'WE8MSWIN1252')

Is there a way with the SQL Server collation ???

How can I solve his problem ???

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2007

Added on Apr 23 2007

#database-key-features, #globalization-support

3 comments

2,896 views