Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

2004-08-24 Thread Martijn Tonies
> > > > I have a questions about "varchar columns" change to "CHAR columns" > > > > automatically. > > > > See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html > > > In addition to that - it doesn't really matter as the CHAR datatype > > isn't properly implemented in MySQL and behaves t

Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

2004-08-23 Thread Joseph Cochran
On Mon, 23 Aug 2004 15:25:21 +0200, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > > I have a questions about "varchar columns" change to "CHAR columns" > > > automatically. > > See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html > In addition to that - it doesn't really matter as th

Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

2004-08-23 Thread Martijn Tonies
> > I have a questions about "varchar columns" change to "CHAR columns" > > automatically. > > See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html In addition to that - it doesn't really matter as the CHAR datatype isn't properly implemented in MySQL and behaves the same as the VARCHA

Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

2004-08-23 Thread Egor Egorov
Emi Lu <[EMAIL PROTECTED]> wrote: > I have a questions about "varchar columns" change to "CHAR columns" > automatically. See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by

Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

2004-08-16 Thread Emi Lu
Hello all, I have a questions about "varchar columns" change to "CHAR columns" automatically. When I designed a table t1 create table t1(id varchar(3) not null) in MySQL. After that, we use "desc t1" to see the description of table "t1". The result is the following: