KNOWLEDGE BASE

Error "Collation mismatch, use COLLATE statements to resolve" When Joining MSSQL and Oracle in Tableau Desktop


Published: 27 Jun 2019
Last Modified Date: 16 Aug 2019

Issue

When joining MSSQL and Oracle in Tableau 2019.2.0 and 2019.2.1, the following error might occur: 

error: collation mismatch, use COLLATE statements to resolve

Environment

  • Tableau Desktop 2019.2.0 - 2019.2.1, 2019.1.0 - 2019.1.5
  • Tableau Server 2019.2.0 - 2019.2.1, 2019.1.0 - 2019.1.5 
  • Microsoft SQL Server & Oracle 

Cause

This behavior is related to a known issue (ID: 932833) which has been corrected in more recent versions of Tableau.

 
Did this article resolve the issue?