[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Migrating mysql4 to etch




On 2007-06-08 Marek Podmaka wrote:
> Thanks for your answer, but my problem is in the different character
> sets used. And this is what was changed between 4.0 and 4.1, so it
> doesn't matter if I upgrade to 4.1 or 5.0.
> The question is how to migrate the data without requiring each
> customer to define in which encoding they have their database.

Experiment a bit with "ALTER TABLE .. CHARSET", default-character-set
in my.cnf and "mysqldump --set-charset". Note that there is a
client and a server setting for the charset, look at:
"show variables like "%char%";"

bye,

-christian-

Attachment: signature.asc
Description: PGP signature


Reply to: