KNOWLEDGE BASE

Oracle database error 12704: ORA-12704: character set mismatch


Published: 03 Jun 2021
Last Modified Date: 03 Jun 2021

Issue

Oracle database error 12704: ORA-12704: character set mismatch. when using a calculated field.

Environment

  • Tableau Desktop 2019.4.0
  • Windows 10
  • Oracle

Resolution

Use TRANSLATE() function to explicitly convert one to the other.

Cause

Per this oracle dba article Strings declared with NCHAR or NCHAR VARYING do not interoperate with strings declared with CHAR or VARCHAR2.
Did this article resolve the issue?