TED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 3:55 PM
Subject: RE: varchar to char ...
> What do you mean by optimization of the column? Are you saying that
> char takes less space than varchar or the performance on char is better
> in queries
ata of the source tables and the
columns. So I don't understand why should/would it change the data
types of columns.
thanks
Vivek
> -Original Message-
> From: bvyas3 [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 14, 2002 6:36 PM
> To: CHAUDHARY, Vivek; mysql
> Cc:
Mysql optimizes the column type while creating the table.
Regards,
Bhavn.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 2:26 PM
Subject: varchar to char ...
> Hi guys,
>
> I have a query.I am not sure if this is a bug or a feature (ha
At 9:32 AM +0100 12/12/01, Willem Bison wrote:
>I have a table with several columns of type 'varchar'. How can I change all
>columns to fixed width char's ? Doing a 'alter' from varchar to char has no
>effect since the column is changed back to varchar.
You have to change them all at ones in the
