I don't like bit values because I can never remember what the values stand for (or is it I can never remember what the values stand for because I never use bit values?).

Anyway, I've seen too many examples where there is no consistency with bit values - sometimes it is Yes/No other times it is No/Yes. I've even seen a True/False turn into a Yes/No half way thorugh a program.

I prefer char(1) fields to tinyint as with tinyint you still need a look up table to tell you what value = 1 means. A single character Y means yes and N means no.

Jeremy

Edited by - Jeremy Kemp on 11/25/2003 07:06:47 AM