choice of field types and performance

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? just to make sure, mysql doesn't store each value selected in the set in each record? or does it? thanks, marko

Re: choice of field types and performance

* 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