[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
ORA-12704 character set mismatch

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

ORA-12704 character set mismatch.


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


Message.


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.



Cause.

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.