change Table Collation

[softvnzla]

As I change from utf8_general_ci to latin1_spanish_ci

:erm:

[Marco van Herwaarden]

And how did you that? You can not simply change the collation and leave the data in the old format. There is a lot more to changing the collation.