PolarDB-O provides the standard SQL type BOOLEAN. BOOLEAN can have one of only two states: TRUE or FALSE. A third state, UNKNOWN, is represented by the SQL NULL value.

Table 1. Boolean type
Name Storage size Description
BOOLEAN 1 byte Logical Boolean (true/false)
Note
  • The valid value for representing the true state is TRUE.
  • The valid value for representing the false state is FALSE.