Facebook
Twitter
U
unixlibre
Guest
Dear all,
I've ran into problems while running the migration manager to migrate from FreeBSD4.9/Plesk7.5.2 to FreeBSD6.0/Plesk8.0. The migration manager complains with
ERROR 1267 (HY000) at line 1: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
It seems that all databases were created with latin1.
The knowledge base says that one must try setting character_set_connection and collation_connection to utf8, which is not entirelly true because collation_connection sould be set to utf8_general_ci.
One way of setting this vars is with the init_connection parameter in my.cnf. The problem is that for admin users, this is not executed (for "security" reasons as stated in mysql docs), so putting this setting in my.cnf has no effect at all.
Anyone of you has a workaround for this?
Thank you in advance.
Antonio
I've ran into problems while running the migration manager to migrate from FreeBSD4.9/Plesk7.5.2 to FreeBSD6.0/Plesk8.0. The migration manager complains with
ERROR 1267 (HY000) at line 1: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
It seems that all databases were created with latin1.
The knowledge base says that one must try setting character_set_connection and collation_connection to utf8, which is not entirelly true because collation_connection sould be set to utf8_general_ci.
One way of setting this vars is with the init_connection parameter in my.cnf. The problem is that for admin users, this is not executed (for "security" reasons as stated in mysql docs), so putting this setting in my.cnf has no effect at all.
Anyone of you has a workaround for this?
Thank you in advance.
Antonio
