MySQL Forums
Forum List  »  Performance

Re: enum vs tinyint
Posted by: David Fells
Date: February 18, 2005 09:50AM

Use enum with values 'New', 'Maintenance', 'Renovation', 'Not Specified' - no need to use a lookup table for this. MySQL internally stores enums as INT(n) fields where n = size of the enumeration, so it's not a space saving mechanism to use 'n', 'm', 'r', 's' in your enum vs using the full strings.

Options: ReplyQuote

Written By
February 18, 2005 02:55AM
Re: enum vs tinyint
February 18, 2005 09:50AM
February 22, 2005 05:25PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.