we have a Sybase ASE SAP with UTF8
and we need to read tables from there into an Oracle 10.2.0.3 SAP which has WE8ISO8859P15.
We are using the Oracle 11g Gateway for that.
Our problem is, that ö,ä,ü for example are not properly converted.
They arrive as ÃŒ in the Oracle database.
Before we migrated our SAP to Sybase ASE SAP it was an Oracle 10.2.0.3 non-unicode SAP System.
Can someone tell me what I have to set on the Oracle gateway that my ö,ä,ü, etc. are converted correctly?