Boolean column - 07/17/2002 11:19 AM
What's the best column type to use for a column which represents a boolean value (0 or 1)?
My guess is CHAR(1) NOT NULL.
I noticed that there's also a CHAR(0) NOT NULL, but its only permissible values are NULL and ''(empty string), which I think would be confusing.
My guess is CHAR(1) NOT NULL.
I noticed that there's also a CHAR(0) NOT NULL, but its only permissible values are NULL and ''(empty string), which I think would be confusing.