Thank you guys so much !!!
I found the answer to all my problems regarding charsets with MySQL
dumps.
Here are the code lines:
CREATE TABLE `foo` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`foo` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
and then :
mysqldump -u {{username}} -p{{password}} {{database}} --default-
character-set=latin1 > file.sql
Thanks !!!
Alexandre Quessy
http://www.sourcelibre.com/
http://www.flikstudio.com/folio/
Le 05-09-06 à 04:32, Gleb Paharenko a écrit :
Hello.
There is no statement which is able to change the collation
and character set information in all tables at once. For single
table use an ALTER TABLE statement. See:
http://dev.mysql.com/doc/mysql/en/alter-table.html
