At 7:20 PM +0200 2000-06-04, Joosten, Juergen wrote:
>I'm quite confused about one thing.
>When I declare one or more rows to have datatype CHAR(...) all is ok.
>But when I additionally declare at least one row to have datatype VARCHAR,
>then all these rows have datatype VARCHAR in the end - the rows declared as
>Even more confusing for me is the fact that rows declared as CHAR(4) or less
>(CHAR(3),...) keep their datatype.
>I'm not quite sure if this is a bug or a feature (performance reasons?), but
>I'd really like to have rows that I declared as CHAR(...) to keep its
>Can someone help me with this?
This is explained in the MySQL Reference Manual:
Paul DuBois, paul@stripped