fields as CHAR i see as VARCHAR

User, date Message
User: JacekBudzyn
Posted: Wed, 28 Jul 10 12:31
Category: General
8 posts since Wed, 28 Jul 10
Hi, when I create table with fields CHAR, in list I see as VARCHAR. Command 'SHOW CREATE TABLE' show me VARCHAR the same.

Its a bug or my fault?
User: anse
Posted: Wed, 28 Jul 10 12:48
1822 posts since Fri, 07 Apr 06
Not a bug, this is done silently by the server while creating a table with CHAR columns. See http://dev.mysql.com/doc/refman/5.0/en/silent-column-changes.html
User: JacekBudzyn
Posted: Wed, 28 Jul 10 13:03
8 posts since Wed, 28 Jul 10
anse: thank you very much for help smile
 

Please login to leave a reply, or register at first.