KNOWLEDGE BASE

"Failure evaluating to database: ERROR: collation mismatch, use COLLATE statements to resolve" When Running a Flow Containing Several Unions


Published: 27 Sep 2019
Last Modified Date: 04 Aug 2020

Issue

When running a flow containing several unions, following error may occur.

"Failure evaluating to database: ERROR: collation mismatch, use COLLATE statements to resolve"

 

Environment

  • Tableau Prep 2019.2.2 ~ 2019.2.3

Cause

This behavior is related to known issue ID 942130 which has been fixed in a recent version of the product. 
Did this article resolve the issue?