* 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