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
---------------------------------------------------------------------
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
