Re: Create Table Bug w/Varchar and Char

Hi,

Take a look here :

http://www.mysql.com/doc/S/i/Silent_column_changes.html

"VARCHAR columns with a length less than four are changed to CHAR. "

Regards,
  Jocelyn Fournier

----- Original Message -----
From: "Mikhail Entaltsev" <mike_lynx@xxxxxxx>
To: "Don Vu" <dvu@xxxxxxxxxxxxxxxxx>; "MySQL Mailing List (E-mail)"
<mysql@xxxxxxxxxxxxxxx>
Sent: Friday, June 28, 2002 10:12 PM
Subject: Re: Create Table Bug w/Varchar and Char


> Don,
>
> check http://www.mysql.com/doc/S/i/Silent_column_changes.html
>
> Mikhail.
>
> ----- Original Message -----
> From: "Don Vu" <dvu@xxxxxxxxxxxxxxxxx>
> To: "MySQL Mailing List (E-mail)" <mysql@xxxxxxxxxxxxxxx>
> Sent: Friday, June 28, 2002 20:00
> Subject: Create Table Bug w/Varchar and Char
>
>
> I'm seeing some freaky behavior from MySQL. Seems as if the column type in
> my CREATE TABLE script isn't being created...i.e. some of the VARCHARs
> become CHARs?!?!
>
> fyi...i'm running MySQL 3.23.37 on Red Hat Linux...
>
> When I try to do this Create Table script:
>
> Create table MemberSummary2 (
>         memberId Varchar(20) NOT NULL ,
>         firstName Varchar(50) ,
>         lastName Varchar(50) ,
>         gender Varchar(1) ,
>         email Varchar(50) ,
>         homePhone Varchar(20) ,
>         address1 Varchar(50) ,
>         address2 Varchar(50) ,
>         city Varchar(20) ,
>         state Varchar(2) ,
>         zip Varchar(5) ,
>         ageGroup Varchar(20) ,
>         birthday Date NULL,
>         moviePref Varchar(50),
>         2ndFirstName Varchar(50) ,
>         2ndLastName Varchar(50) ,
>         2ndGender Varchar(1) ,
>         2ndBirthday Date NULL,
>         planTypeId Integer(11) ,
>         purchaseDate Date NULL,
>         purchaseAmt Float(4,2) ,
>         charterFlag Varchar(1) ,
>         paymentType Varchar(20) ,
>         giftRecd Varchar(1) ,
>         tempCard Varchar(1) ,
>         inputInit Varchar(3) ,
>         http_date Varchar(20),
>         http_time Time ,
>         sentEmail Varchar(1) ,
>  Primary Key (memberId)
> );
>
> I get this:
>
> mysql> source test.sql
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> desc MemberSummary2;
> +--------------+-------------+------+-----+---------+-------+
> | Field        | Type        | Null | Key | Default | Extra |
> +--------------+-------------+------+-----+---------+-------+
> | memberId     | varchar(20) |      | PRI |         |       |
> | firstName    | varchar(50) | YES  |     | NULL    |       |
> | lastName     | varchar(50) | YES  |     | NULL    |       |
> | gender       | char(1)     | YES  |     | NULL    |       |
> | email        | varchar(50) | YES  |     | NULL    |       |
> | homePhone    | varchar(20) | YES  |     | NULL    |       |
> | address1     | varchar(50) | YES  |     | NULL    |       |
> | address2     | varchar(50) | YES  |     | NULL    |       |
> | city         | varchar(20) | YES  |     | NULL    |       |
> | state        | char(2)     | YES  |     | NULL    |       |
> | zip          | varchar(5)  | YES  |     | NULL    |       |
> | ageGroup     | varchar(20) | YES  |     | NULL    |       |
> | birthday     | date        | YES  |     | NULL    |       |
> | moviePref    | varchar(50) | YES  |     | NULL    |       |
> | 2ndFirstName | varchar(50) | YES  |     | NULL    |       |
> | 2ndLastName  | varchar(50) | YES  |     | NULL    |       |
> | 2ndGender    | char(1)     | YES  |     | NULL    |       |
> | 2ndBirthday  | date        | YES  |     | NULL    |       |
> | planTypeId   | int(11)     | YES  |     | NULL    |       |
> | purchaseDate | date        | YES  |     | NULL    |       |
> | purchaseAmt  | float(4,2)  | YES  |     | NULL    |       |
> | charterFlag  | char(1)     | YES  |     | NULL    |       |
> | paymentType  | varchar(20) | YES  |     | NULL    |       |
> | giftRecd     | char(1)     | YES  |     | NULL    |       |
> | tempCard     | char(1)     | YES  |     | NULL    |       |
> | inputInit    | char(3)     | YES  |     | NULL    |       |
> | http_date    | varchar(20) | YES  |     | NULL    |       |
> | http_time    | time        | YES  |     | NULL    |       |
> | sentEmail    | char(1)     | YES  |     | NULL    |       |
> +--------------+-------------+------+-----+---------+-------+
> 29 rows in set (0.00 sec)
>
> How does the Gender, State, etc. go from Varchar to Char?
>
> any insight appreciated...
>
> -Don
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread113342@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-mike_lynx=smtp.ru@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread113355@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-joc=presence-pc.com@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>


---------------------------------------------------------------------
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 <mysql-thread113360@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php