This is documented in the manual
<http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html>.
Michael
Nupur Jain wrote:
I am not sure what I am noticing is the intended behavior of MySql. I created
my table with CHAR(15) data types. When I describe the table, it appears as
VARCHAR(15) ..
Here are the statements -
alter table mytable add (loc char(15));
Query OK, 1 row affected, 1 warning (0.02 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> describe mytable;
+---------+-------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+-------------------+-------+
| name | varchar(12) | YES | | NULL | |
| is_emp | tinyint(4) | YES | | NULL | |
| dept | smallint(6) | YES | | NULL | |
| salary | float | YES | | NULL | |
| company | varchar(12) | YES | | NULL | |
| etime | timestamp | YES | | CURRENT_TIMESTAMP | |
| loc | varchar(15) | YES | | NULL | |
+---------+-------------+------+-----+-------------------+-------+
7 rows in set (0.00 sec)
Only when I add a field with as CHAR , it shows up as CHAR(1). Any
explanations???
I have the solaris 32 bit MySQL-MAX package installed. Version is 4.1.9.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
