KNOWLEDGE BASE

Error "Illegal mix of collations" Filtering On Calculated Field


Published: 26 Sep 2016
Last Modified Date: 26 Sep 2016

Issue

When you try to filter on a calculated field that contains "NULL", the following error occurs: 

An error occured while communicating with data source... 
The connection to the data source might have been lost. 
[MySQL][ODBC 5.3(w) Driver][mysqld-5.1.33-community​]Illegal mix of collations (utf8_bin,NONE) AND (utf8_general,COERCIBLE) for operation 
prepare.xml class DataSourceException

Environment

Tableau Desktop
MySQL

Resolution

In the affected calculated field, replace NULL with " ".
 
Did this article resolve the issue?