You are currently reviewing an older revision of this page.
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'
This issue is seen when the tables called by the view have a different collation setup.
Ensure that the collation of all the tables matches. If this issue occurs in a cloud site follow the steps here:
If this occurs in an on-premise environment, engage the DBA team responsible for maintaining the database.
This article applies to all versions of Appian.
Last Reviewed: December 2018
© 2023 Appian. All rights reserved.