Loading

Error "Illegal mix of collations" Filtering On Calculated Field

Publiceringsdatum: Jun 13, 2025
Beskrivning
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
Lösning
In the affected calculated field, replace NULL with " ".
 
Knowledge-artikelnummer

001473279

 
Laddar
Salesforce Help | Article