Encoding - MySQL

[Marek]

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

[lark]

Marek Simon wrote: 

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_ CONVERT TO CHARACTER SET utf8 COLLATE utf8_persian_ci;

replace collation and/or character set as appropriate

[Joachim]

lark schrieb: 

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

[Willem]

>> ALTER TABLE table_ CONVERT TO CHARACTER SET utf8 COLLATE 
>
> 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.[/ref]

That is exactly what the above statement does. If you only want to
change the default, use something like:
ALTER TABLE table_ CHARACTER SET=utf8;

--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/