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]
