BOOLEAN
The BOOLEAN
data type provides 1 byte of storage for logical values.
Syntax
BOOLEAN
Corresponding Compile-time Java Type
java.lang.Boolean
JDBC Metadata Type (java.sql.Types)
BOOLEAN
Usage Notes
Here are several usage notes for the BOOLEAN
data type:
- The legal values are
true
,false
, andnull
. BOOLEAN
values can be cast to and from character type values.- For comparisons and ordering operations,
true
sorts higher thanfalse
.
Examples
values true;
values false;
values cast (null as boolean);