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.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

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


-
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