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