KB-1822 Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) causes failure to load a view
Symptoms
The following error displays in the browser while trying to load a record or report:
#1267 - Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) for operation 'substring_index'
Cause
This issue is seen when the tables called by the view have a different collation setup.
Action
Cloud Environment
Ensure that the collation of all tables match by following these steps:
- Access the database (
https://<SITE-NAME>/database). - Navigate to the table which is throwing the error.
- Open the "Operation" tab for the table.
- Set the Collation under "Table Option".
Self-managed Environment
Engage the DBA team responsible for maintaining the database.
Affected Versions
This article applies to all versions of Appian.
Last Reviewed: December 2018