Subject RE: [ib-support] Metadata opinions appreciated (warning large post)
Author Alan McDonald
Here's another way

CREATE DOMAIN T_YESNO AS
CHAR(1) CHARACTER SET NONE
DEFAULT 'N'
CHECK ((VALUE IS NULL) OR (VALUE IN ('N','Y')))
COLLATE NONE