Hello,

> those 'silent column specification changes' affect all table types. That
> feature has caused lots of user questions over years. It is in the TODO to
> remove that feature from MySQL, because it is not standards compliant. In
> InnoDB, a reason to use a CHAR column in some cases is to reduce
> fragmentation if there are lots of updates to that column. A CHAR column
> takes a fixed space. Silent column specification changes in many cases
> defeat this optimization which would otherwise be available to users.

I had a very long discussion with someone about this...

He said the same as you.

IMO, this is rubbish. Why should a CHAR column take
up fixed space??

CHAR is a logical datatype. How you store it physically
is up to the database engine implemenation.

That means you can store it as number of flowers in a
vase, or whatever ;-)

No, seriously: there's no reason why you cannot store
CHARs as VARCHARs, or put an extra compression
over it, and return/use the values as char-padded values.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to