VARCHAR/CHAR problem

I give this query: ALTER TABLE `companies` ADD `Tel3` CHAR(30) BINARY but it creates tel3 as VARCHAR(30) ! Why? Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: VARCHAR/CHAR problem

At 15:39 +0200 3/4/02, savaidis wrote: I give this query: ALTER TABLE `companies` ADD `Tel3` CHAR(30) BINARY but it creates tel3 as VARCHAR(30) ! You have other variable-length columns in your table. http://www.mysql.com/doc/S/i/Silent_column_changes.html Why? Makis