I have a EE 1.6.7 site with a utf8_bin collation in columns in the donations table and latin1_swedish_ci collation in text columns in the other tables.
Is this a problem? I did not make this site, I just want to upgrade it.
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
August 14, 2010 12:27pm
Subscribe [2]#1 / Aug 14, 2010 12:27pm
I have a EE 1.6.7 site with a utf8_bin collation in columns in the donations table and latin1_swedish_ci collation in text columns in the other tables.
Is this a problem? I did not make this site, I just want to upgrade it.
#2 / Aug 15, 2010 8:09am
Hi ACT,
I have merged your other two threads so it’s easier to deal with but the answer to this question is no, it should not be a problem. MySQL allows you to mix and match collations without issue. In terms of an upgrade, EE will change all tables to UTF-8 during the upgrade process.
Cheers
Greg