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, and null.
  • BOOLEAN values can be cast to and from character type values.
  • For comparisons and ordering operations, true sorts higher than false.

Examples

values true;
values false;
values cast (null as boolean);