MySQL – ERROR 1273 (HY000): Unknown collation ‘#253’ in table ‘some-table’ definition

Published on Author gryzliLeave a comment

Some background… Recently we’ve made some migrations from Percona MySQL Server 5.1 to MySQL 5.5.   It seems that Percona MySQL Server, have additional collations, which if used will cause problems after migrating to pure MySQL. In my case the problematic collation was: utf8_general50_ci  –>  Corresponding to id #253 in MySQL collations After the migration,… Continue reading MySQL – ERROR 1273 (HY000): Unknown collation ‘#253’ in table ‘some-table’ definition