* Marko Djukic > what is generally better to use: > - one field of type 'set' (eg.: 'apples','cherries','pears','bananas') > - or multiple fields of type true/false for each value above?
Field type SET, because the field types BIT and BOOL are 'fake' (synonyms for TINYINT), occupying a full byte for each field. > just to make sure, mysql doesn't store each value selected in the > set in each record? or does it? No, only one bit is used for each value in the SET (minimum 8 bits/row, maximum 64). <URL: http://www.mysql.com/doc/S/E/SET.html > -- Roger --------------------------------------------------------------------- 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