Hello all,
I have a questions about "varchar columns" change to "CHAR columns" automatically.
When I designed a table t1
create table t1(id varchar(3) not null) in MySQL. After that, we use "desc t1" to see the description of table "t1".
The result is the following: =============================== +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | id | char(3) | YES | | NULL | | +-------+---------+------+-----+---------+-------+
I did not understand why the varchar(3) is changed to char(3) automatically. While if we define a varchar(4) it will not change to char(4) automatically. Could somebody help and explain that please?
Thanks a lot! Emi Lu
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]