http://dev.mysql.com/doc/mysql/en/silent-column-changes.html
At 21:29 -0500 5/28/05, Philip George wrote:
when i create a table with:
CREATE TABLE person (
id char(36) NOT NULL PRIMARY KEY,
firstname varchar(50) DEFAULT NULL,
lastname varchar(50) DEFAULT NULL
);
...and then use describe to show what i've got:
mysql> describe person;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| id | varchar(36) | | PRI | | |
| firstname | varchar(50) | YES | | NULL | |
| lastname | varchar(50) | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
...`id`, which is supposed to be char(36), is actually varchar(36).
SHOW CREATE TABLE shows the same thing.
it's not a big problem. just wondering what's going on here. i
checked http://dev.mysql.com/doc/mysql/en/char.html , but found
nothing related to this.
i'm running version 4.1.11.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]