October 2001
Beginner to intermediate
400 pages
7h 45m
English
Logical data types are used to represent the concepts of true, false, or NULL. Typically, this data type is useful as a flag that indicates the current state of a record. The true and false values are self-explanatory, while the value NULL usually indicates the equivalent of “unknown.”
Holds a logical true, a logical false, or a NULL value.
TRUE, t, true, y, yes, 1—All valid TRUE values.
FALSE, f, false, n, no, 0—All valid FALSE values.
NULL—Valid NULL value.
1 byte
Generally, it is best to use the TRUE and FALSE input forms for Boolean data. These formats are SQL compatible and generally are more accepted, although some RDBMSs use 1 and 0 for TRUE and FALSE representations. ...
Read now
Unlock full access