[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

ORA-12704 character set mismatch



Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019

ORA-12704 character set mismatch.

Applies to: Business Objects, Oracle 9i on Red Hat Linux, SQL Server 2005 Enterprise Edition


ORA-12704: character set mismatch


Problem Description.

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.



.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.