Re: How concerned should I be about Collation?

2005-09-07 Thread 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

Re: How concerned should I be about Collation?

2005-09-06 Thread Gleb Paharenko
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 Dave [EMAIL PROTECTED] wrote: MySQL General List,

How concerned should I be about Collation?

2005-09-05 Thread Dave
MySQL General List, Server specifications: MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8 My specifications: MySQL beginner, PHP intermediate, HTML and CSS advanced. The situation: I have a database of users for my web site, in which all the text data that is inserted