Tweet
In older installations, there is a problem with collision mismatch between fields within tables.
As a result, there are performance problems, in particular, the newly added fields of the image type have the utf8_unicode_ci id in the attachment and utf8mb4_unicode_ci in the image_id field in the entity.
I believe that the solution to the problem is to change collations for all fields.
Something like this:
Or maybe yuri will make a corresponding patch
As a result, there are performance problems, in particular, the newly added fields of the image type have the utf8_unicode_ci id in the attachment and utf8mb4_unicode_ci in the image_id field in the entity.
I believe that the solution to the problem is to change collations for all fields.
Something like this:
Code:
select COLUMNS.COLLATION_NAME,COLUMNS.COLUMN_TYPE , CONCAT('alter table ', TABLE_SCHEMA, '.', TABLE_NAME, ' MODIFY column ', COLUMN_NAME,' ',COLUMN_TYPE, ' COLLATE utf8mb4_unicode_ci;') from information_schema.COLUMNS WHERE TABLE_SCHEMA = 'petunicrm' and COLUMNS.COLLATION_NAME<>'utf8mb4_unicode_ci';