Re: change character set for databases

[Alexander Barkov]

ALTER DATABASE changes only default charset, it does not
alter the tables.

You need to run this query in a loop:

for each table
ALTER TABLE table_XXX CONVERT TO CHARACTER SET utf8 COLLATE utf8_persian_ci;