subject:"VARCHAR\/CHAR problem"

Re: VARCHAR/CHAR problem

2002-03-04 Thread 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

VARCHAR/CHAR problem

2002-03-04 Thread savaidis

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) http://lists.mysql.