t sql boolean variable code example
Example 1: boolean in sql
#Oracle
#The recommended way of storing booleans in Oracle SQL is to use a NUMBER(1) field.
#This can store 1 as true and 0 as false.
CREATE TABLE testbool (
sometext VARCHAR2(10),
is_checked NUMBER(1)
);
#SQL Server
#A BIT data type is used to store bit values from 1 to 64.
#1 for TRUE and 0 for FALSE.
CREATE TABLE testbool (
sometext VARCHAR(10),
is_checked BIT
);
#MySQL
#A BIT data type is used to store bit values from 1 to 64.
#1 for TRUE and 0 for FALSE.
CREATE TABLE testbool (
sometext VARCHAR(10),
is_checked BIT(1)
);
#PostgreSQL
#PostgreSQL has a Boolean Data Type
#TRUE: represented by TRUE, ‘t’, ‘true’, ‘y’, ‘yes’, ‘on’, ‘1’
#FALSE: represented by FALSE, ‘f’, ‘false’, ‘n’, ‘no’, ‘off’, ‘0’
CREATE TABLE testbool (
sometext TEXT,
is_checked BOOLEAN
);
Example 2: sql boolean data type
Oracle: NUMBER(1)
SQL server: BIT