You are currently reviewing an older revision of this page.
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'
This issue is witnessed when the tables called by the view have different collation setup.
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"
This article applies to all versions of Appian.
Last Reviewed: December 2018