[SQL] SQL design question: null vs. boolean values

Hi all: I was wondering if anyone had recommendations for the following scenarios: (A) I have three radio boxes in the user form field_foo []yes []no []unknown These are mutually exclusive and user input is always required. So in the database, should I have something like: field_foo ch

Re: [SQL] SQL design question: null vs. boolean values

Hi: > > (A) > > I have three radio boxes in the user form > > > > field_foo > > []yes > > []no > > []unknown > > ... > > field_foo char(1) not null check > > (field_foo in 'y', 'n', 'u') > > OR > > field_foo char(1) check (field_foo in 'y', 'n') > > > Option 1 - the