SQL Column Types
MySQL/MariaDB
HCL | SQL | Attributes | Example |
---|---|---|---|
bigint | bigint |
|
|
binary | binary |
|
|
bit | bit |
|
|
blob | blob |
|
|
bool | bool |
| |
boolean | boolean |
| |
char | char |
|
|
date | date |
|
|
datetime | datetime |
|
|
decimal | decimal |
|
|
double | double |
|
|
enum | enum |
|
|
float | float |
|
|
geometry | geometry |
| |
geometrycollection | geometrycollection |
| |
int | int |
|
|
json | json |
| |
linestring | linestring |
| |
longblob | longblob |
| |
longtext | longtext |
| |
mediumblob | mediumblob |
| |
mediumint | mediumint |
|
|
mediumtext | mediumtext |
| |
multilinestring | multilinestring |
| |
multipoint | multipoint |
| |
multipolygon | multipolygon |
| |
numeric | numeric |
|
|
point | point |
| |
polygon | polygon |
| |
real | real |
|
|
set | set |
|
|
smallint | smallint |
|
|
text | text |
|
|
time | time |
|
|
timestamp | timestamp |
|
|
tinyblob | tinyblob |
| |
tinyint | tinyint |
|
|
tinytext | tinytext |
| |
varbinary | varbinary |
|
|
varchar | varchar |
|
|
year | year |
|
|
Postgres
HCL | SQL | Attributes | Example |
---|---|---|---|
bigint | bigint |
| |
bigserial | bigserial |
| |
bit | bit |
|
|
bit_varying | bit varying |
|
|
bool | bool |
| |
boolean | boolean |
| |
box | box |
| |
bytea | bytea |
| |
char | char |
|
|
character | character |
|
|
character_varying | character varying |
|
|
cidr | cidr |
| |
circle | circle |
| |
date | date |
| |
decimal | decimal |
| |
double_precision | double precision |
| |
enum | my_enum |
| |
float4 | float4 |
| |
float8 | float8 |
| |
hstore | hstore |
| |
inet | inet |
| |
int | int |
| |
int2 | int2 |
| |
int4 | int4 |
| |
int8 | int8 |
| |
integer | integer |
| |
json | json |
| |
jsonb | jsonb |
| |
line | line |
| |
lseg | lseg |
| |
macaddr | macaddr |
| |
macaddr8 | macaddr8 |
| |
money | money |
| |
numeric | numeric |
| |
path | path |
| |
point | point |
| |
real | real |
| |
serial | serial |
| |
serial2 | serial2 |
| |
serial4 | serial4 |
| |
serial8 | serial8 |
| |
smallint | smallint |
| |
smallserial | smallserial |
| |
sql | sql |
|
|
text | text |
| |
time | time |
|
|
timestamp | timestamp |
|
|
timestamptz | timestamptz |
|
|
timetz | timetz |
|
|
uuid | uuid |
| |
varchar | varchar |
|
|
xml | xml |
|
SQLite
HCL | SQL | Attributes | Example |
---|---|---|---|
bigint | bigint |
|
|
blob | blob |
|
|
boolean | boolean |
| |
character | character |
|
|
clob | clob |
|
|
date | date |
| |
datetime | datetime |
| |
decimal | decimal |
|
|
double | double |
|
|
double_precision | double precision |
|
|
float | float |
|
|
int | int |
|
|
int2 | int2 |
|
|
int8 | int8 |
|
|
integer | integer |
|
|
json | json |
| |
mediumint | mediumint |
|
|
native_character | native character |
|
|
nchar | nchar |
|
|
numeric | numeric |
|
|
nvarchar | nvarchar |
|
|
real | real |
|
|
smallint | smallint |
|
|
text | text |
|
|
tinyint | tinyint |
|
|
unsigned_big_int | unsigned big int |
|
|
uuid | uuid |
| |
varchar | varchar |
|
|
varying_character | varying character |
|
|