You are currently reviewing an older revision of this page.

DRAFFT KB - XXXX Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) caused failure to load a view

Symptoms

Following error is witnessed on the browser while trying to load a record: 

#1267 - Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) for operation 'substring_index' 

Cause

This issue is witnessed when the tables called by the view have different collation setup. 

Action

Ensure that the collation of all the tables matches. This can be done using the following steps: 

1. Access the database (https://<site-name>/database)

2. Navigate to the table which is throwing the error

3. Open the "Operation" tab for the table.

4. Set the Collation under "Table Option"

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: December 2018