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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php