Performance problems on old install (before v.7)

[dimyy]

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:

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';

Or maybe yuri will make a corresponding patch