Mattias,
> which one is the biggest datatype:
> enum('true', 'false'); OR
> tinyint(1);
> I mena biggest when it comes to store them on disk.
ENUM has a storage requirement of 1 or 2 bytes. If you have up to 256
ENUM values to choose from, you need 1 byte, if you have more, it will
take 2 bytes. TINYINT will always need 1 byte.
http://www.mysql.com/doc/en/Storage_requirements.html
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
