Alec Solway wrote:
>
> Hi,
>
> In various create table statements char columns are converted to varchar..
> I was wondering why this was happening. Here's an example:
>
> CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not
> null, city VARCHAR(255) not null, state CHAR(2) not null, country CHAR(2)
> not null, zip CHAR(5) not null, phone VARCHAR(50) not null, cell
> VARCHAR(50) not null, fax VARCHAR(50) not null, nvio VARCHAR(25) not null,
> estlead CHAR(5) not null, servicearea VARCHAR(255) not null);
> Query OK, 0 rows affected (0.11 sec)
>
> Here, zip and estlead have been converted to varchar(5).
>
> Thanks.
> Alec
>
see the manual
www.mysql.com/doc
There is no problem here, that is standard be behaviour, by having any
variable size columns on a row you defeat the advantage of fixed length
rows so the db might as well use varchar to save space, so it does.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php