Marek Simon wrote:
> I have moved DB from one to another machine, but I forgot to set up the
> encoding of databases, so some of them are wrong. Is it possible to
> change database/table/column encoding without a need of exporting data,
> re-create the database and importing the data?
> Marek Simon, Prague, Czech Republic

run this for your data abase:

ALTER DATABASE db_name
DEFAULT CHARACTER SET utf8 COLLATE utf8_persian_ci




then run this for each table already in the database :

ALTER TABLE table_XXX CONVERT TO CHARACTER SET utf8 COLLATE utf8_persian_ci;

replace collation and/or character set as appropriate