Oracle Database and Character Set Missmatch
Hi everyone,
this week i set up a BDC connection to an Oracle Server - 8.7.1 to be precise. I also had to install the oracle client software - also 8.7.1. Everything worked fine - i was able to see all the rows of the table inside of MOSS. Then i came across one problem: i tried to add a FilterDescriptor mapped to an "in"-Parameter with type string. In the database the column i would like to filter for is of type Varchar.
There my problem began. I wasn't able to query anything anymore. A look into the Moss log-File revealed a Oracle Exception saying:ORA-12704: character set mismatch. A direct select statement via SQLPlus did complete correctly. So my guess is that the statement that is generated via BDC has to be flagged somehow so the server accepts the character set.
Is there anybody out there being able to help me ? Is it possible to rewrite the SQL-Statement so that the parameter is passed to the server in the correct way ?
The Servers Character Set is the following :
WE8ISO8859P19
So it is not unicode.
TIA,
Oliver
