lark schrieb:
>
> ALTER TABLE table_XXX CONVERT TO CHARACTER SET utf8 COLLATE
> utf8_persian_ci;
>
> replace collation and/or character set as appropriate

Wouldn't you have to alter the column definitions as well?
IIRC altering the table would only change the defaults for columns that
are added without specifying a character set and collation.

Regards,
Jo