java.sql.SQLException: ORA-12704: character set mismatch error in DV

Solution Verified - Updated -

Issue

  • Query with 2 tables with two different data type columns into single column using union gives Oracle error ORA-12704: character set mismatch

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.3, 6.4
  • Oracle column with NVARCHAR2 datatype

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In