ORA-12704 character set mismatch.
Applies to: Business Objects, Oracle 9i on Red Hat Linux, SQL Server 2005
ORA-12704: character set mismatch
We were creating a report in Business Objects that was using a query, joining
tables from an Oracle 9i server and from a SQL Server 2005 instance. We were
using a DB LINK from oracle to access the Microsoft SQL Server tables. We
received the above error from Business Objects because one of the Microsoft SQL
Server tables involved in the join was using user-defined data types.
Create a view for every table in Microsoft SQL Server that use user-defined data
types, and convert those fields using user-defined data types to SQL Server
native data types on the view.