Re: VARCHAR/CHAR problem

[Paul DuBois]

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