Re: How concerned should I be about Collation?

[Alexandre Quessy]

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