BIT(n)

Description

Fixed-length binary or hexadecimal bit strings are represented as BIT(n), where n is the maximum number of bits. If n is not specified, the length is set to 1.

Remark
Example

CREATE TABLE bit_tbl(a1 BIT, a2 BIT(1), a3 BIT(8), a4 BIT VARYING);

INSERT INTO bit_tbl VALUES (B'1', B'1', B'1', B'1');

INSERT INTO bit_tbl VALUES (0b1, 0b1, 0b1, 0b1);

INSERT INTO bit_tbl(a3,a4) VALUES (B'1010', B'1010');

INSERT INTO bit_tbl(a3,a4) VALUES (0xaa, 0xaa);

SELECT * FROM bit_tbl;

  a1                    a2                    a3                    a4

 

=========================================================================

  X'8'                  X'8'                  X'80'                 X'8'

  X'8'                  X'8'                  X'80'                 X'8'

  NULL                  NULL                  X'a0'                 X'a'

  NULL                  NULL                  X'aa'                 X'aa'