boolean in sql

1#Oracle
2#The recommended way of storing booleans in Oracle SQL is to use a NUMBER(1) field.
3#This can store 1 as true and 0 as false.
4
5CREATE TABLE testbool (
6  sometext VARCHAR2(10),
7  is_checked NUMBER(1)
8);
9
10
11#SQL Server
12#A BIT data type is used to store bit values from 1 to 64.
13#1 for TRUE and 0 for FALSE.
14
15CREATE TABLE testbool (
16  sometext VARCHAR(10),
17  is_checked BIT
18);
19
20
21#MySQL
22#A BIT data type is used to store bit values from 1 to 64.
23#1 for TRUE and 0 for FALSE.
24
25CREATE TABLE testbool (
26  sometext VARCHAR(10),
27  is_checked BIT(1)
28);
29
30
31#PostgreSQL
32#PostgreSQL has a Boolean Data Type
33#TRUE: represented by TRUE, ‘t’, ‘true’, ‘y’, ‘yes’, ‘on’, ‘1’
34#FALSE: represented by FALSE, ‘f’, ‘false’, ‘n’, ‘no’, ‘off’, ‘0’
35
36CREATE TABLE testbool (
37  sometext TEXT,
38  is_checked BOOLEAN
39);

1Oracle: NUMBER(1)
2SQL server: BIT