Hi!

On Jan 24, Stefan Hinz wrote:
> Dear gurus,
> 
> does someone have background information on the following problem ("How
> does MySQL do this?"):
> 
> CREATE TABLE myisamFixed (col VARCHAR(10)) TYPE=MyISAM ROW_FORMAT=FIXED;
> CREATE TABLE myisamDynamic (col CHAR(10))  TYPE=MyISAM
> ROW_FORMAT=DYNAMIC;
> 
> SHOW TABLE STATUS LIKE 'myisam%';
> +----------------------+--------+------------+
> | Name                 | Type   | Row_format |
> +----------------------+--------+------------+
> | myisamDynamic        | MyISAM | Dynamic    |
> | myisamFixed          | MyISAM | Fixed      |
> +----------------------+--------+------------+
> 
> Regards,
> --
>   Stefan Hinz <[EMAIL PROTECTED]>
>   Gesch?ftsf?hrer / CEO iConnect GmbH <http://iConnect.de>
>   Heesestr. 6, 12169 Berlin (Germany)
>   Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

Did you try 'SHOW CREATE TABLE' for these tables ?   :)
You'd found that myisamFixed.col is, in fact CHAR(10),
and in myisamDynamic.col is VARCHAR(10).

The answer to the question ("How does ...") is "By silent column type
conversion".
 
Regards,
Sergei

-- 
MySQL Development Team
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/

---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to