connect to Oracle DB via linked server - no umlauts
678351Jan 6 2009 — edited Mar 9 2009Hello
I try to connect from MS SQL 2005 to an Oracle DB (version 10.2) via linked server. The connection is working and querying a Select statement through OpenQuery returns the correct data. There is just one issue. The result is without umlauts, special german characters. Instead of
"Ü" -> "U",
"Ö" -> "O",
"Ä" -> "A"
So words are different to their original: e.g. "Störung" is just "Storung", ...
The settings for the linked server are:
Provider: Microsoft OLE DB Provider for Oracle
ProductName: XXXX
Datasource: (DESCRIPTION=(SDU=32768)(ADDRESS_LIST=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=XXX.XXX.XXX.XXX)(PORT=1504)))(CONNECT_DATA=(SID=BWP)(GLOBAL_NAME=BWP.WORLD)))
Server Options:
- Collation Compatible = false
- Use Remote Collation = false
- Collation Name = SQL_Latin1_General_CP437_CS_AS
Thank you for any hints!
Best Regards Maria