AdeliaType |
Oracle Type |
MySQL Type |
PostgreSQL Type | DB2 Type |
Access Type |
ODBC Type |
SQL Server |
BTrieve Type |
DB2/400 Type |
ALPHA(x) |
if x <= 2000 char(x) if x <= 4000 varchar(x) if x > 4000 long varchar |
if x <= 255 char(x) if x <= 65532 varchar(x) if x <= 65536 text if x <= 16777216 mediumtext if x > 16777216 longtext |
char | if x <= 254 char(x) if x <= 3098 varchar(x) if x > 3098 clob(x) |
if x <= 255 char(x) if x > 255 memo |
driver queried |
if x <= 8000 char(x) if x > 8000 text varchar(max) |
alpha |
if x <= 32765 alpha if x > 32765 clob |
ALPHA(x)(variable) |
if x <= 4000 varchar2(x) if x > 4000 clob |
if x <= 65532 varchar(x) if x <= 65536 text if x <= 16777216 mediumtext if x > 16777216 longtext |
varchar | if x <= 3098 varchar(x) if x > 3098 clob(x) |
if x <= 255 varchar(x) if x > 255 memo |
driver queried |
if x <= 8000 varchar(x) if x > 8000 text varchar(max) |
alpha |
if x <= 32765 alpha if x > 32765 clob |
ALPHA(x) (unicode) |
if x <= 1000 nchar(x) if x <= 2000 nvarchar(x) if x > 2000 nclob |
if x <= 255 char(x) character set utf8 if x <= 65532 varchar(x) character set utf8 if x <= 65536 text character set utf8 if x <= 16777216 mediumtext character set utf8 if x > 16777216 longtext character set utf8 |
char | if x <= 127 graphic(x) if x <= 2000 vargraphic(x) if x > 2000 dbclob(x) |
if x <= 255 char(x) if x > 255 memo |
driver queried |
if x <= 4000 nchar(x) if x > 4000 ntext nvarchar(max) |
-na- |
if x <= 16382 graphic ccsid 13488 if x >16382 dbclob ccsid 13488 |
ALPHA(x) (unicode, variable) |
if x <= 2000 nvarchar(x) if x > 2000 nclob |
if x <= 65532 varchar(x) character set utf8 if x <= 65536 text character set utf8 if x <= 16777216 mediumtext character set utf8 if x > 16777216 longtext character set utf8 |
varchar | if x <= 2000 vargraphic(x) if x > 2000 dbclob(x) |
if x <= 255 char(x) if x > 255 memo |
driver queried |
if x <= 4000 nvarchar(x) if x > 4000 ntext nvarchar(max) |
-na- |
if x <= 16382 graphic ccsid 13488 if x >16382 dbclob ccsid 13488 |
NUM_E(x, y) NUM_P(x, y) |
number(x, y) |
float (x, y) |
numeric (x, y) | decimal(x,y) |
double |
driver queried |
numeric(x,y) |
numerical (extended |
numerical (extended |
NUM_BIN_2 |
number (5) |
smallint |
smallint |
smallint |
smallint |
driver queried |
smallint |
bin2 |
binary(4.0) |
NUM_BIN_4 |
number (10) |
int |
integer | integer |
int |
driver queried |
integer |
bin4 |
binary(9.0) |
NUM_BIN_8 |
number (19) |
bigint |
bigint | bigint |
decimal(19,0) |
driver queried |
bigint |
not supported |
bigint |
BOOL |
not supported |
not supported |
not supported |
not supported |
not supported |
not supported |
not supported |
not supported |
not supported |
DATE |
date |
date |
date | date |
datetime |
driver queried |
date |
date |
date |
TIME |
date |
time |
time |
time |
datetime |
driver queried |
date |
time |
time |
TIMESTAMP |
timestamp |
timestamp |
timestamp | timestamp |
datetime |
driver queried |
datetime2 |
not supported |
timestamp |
IMAGE |
blob* |
longblob |
bytea | blob (1G) |
image |
driver queried |
varbinary(max) |
not supported |
blob |