Type Adélia |
Type Oracle |
Type MySQL |
Type PostgreSQL |
Type DB2 |
Type Access |
Type ODBC |
Type SQL Server |
Type BTrieve |
Type DB2/400 |
ALPHA(x) |
si x<= 2000 char(x) si x <= 4000 varchar2(x) si x > 4000 clob |
si x <= 255 char(x) si x <= 65532 varchar(x) si x <= 65536 text si x <= 16777216 mediumtext si x > 16777216 longtext |
char | si x <= 254 char(x) si x <= 3098 varchar(x) si x > 3098 clob(x) |
si x <= 255 char(x) si x > 255 memo |
interrogation du driver |
si x <= 8000 char(x) si x > 8000 varchar(max) |
alpha |
si x <= 32765 alpha si x > 32765 clob |
ALPHA(x)(variable) |
si x <= 4000 varchar2(x) si x > 4000 clob |
si x <= 65532 varchar(x) si x <= 65536 text si x <= 16777216 mediumtext si x > 16777216 longtext |
varchar | si x <= 3098 varchar(x) si x > 3098 clob(x) |
si x <= 255 varchar(x) si x > 255 memo |
interrogation du driver |
si x <= 8000 varchar(x) si x > 8000 varchar(max) |
alpha |
si x <= 32765 alpha si x > 32765 clob |
ALPHA(x)(unicode) |
si x <= 1000 nchar(x) si x <= 2000 nvarchar(x) si x > 2000 nclob |
si x <= 255 char(x) character set utf8 si x <= 65532 varchar(x) character set utf8 si x <= 65536 text character set utf8 si x <= 16777216 mediumtext character set utf8 si x > 16777216 longtext character set utf8 |
char | si x <= 127 graphic(x) si x <= 2000 vargraphic(x) si x > 2000 dbclob(x) |
si x <= 255 char(x) si x > 255 memo |
interrogation du driver |
si x <= 4000 nchar(x) si x > 4000 nvarchar(max) |
-na- |
si x <= 16382 graphic ccsid 13488 si x >16382 dbclob ccsid 13488 |
ALPHA(x)(unicode, variable) |
si x <= 2000 nvarchar(x) si x > 2000 nclob |
si x <= 65532 varchar(x) character set utf8 si x <= 65536 text character set utf8 si x <= 16777216 mediumtext character set utf8 si x > 16777216 longtext character set utf8 |
varchar | si x <= 2000 vargraphic(x) si x > 2000 dbclob(x) |
si x <= 255 char(x) si x > 255 memo |
interrogation du driver |
si x <= 4000 nvarchar(x) si x > 4000 nvarchar(max) |
-na- |
si x <= 16382 graphic ccsid 13488 si 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 |
interrogation du driver |
numeric(x,y) |
numérique (étendu |
numérique (étendu |
NUM_BIN_2 |
number (5) |
smallint |
smallint |
smallint |
smallint |
interrogation du driver |
smallint |
bin2 |
binaire(4.0) |
NUM_BIN_4 |
number (10) |
int |
integer |
integer |
int |
interrogation du driver |
integer |
bin4 |
binaire(9.0) |
NUM_BIN_8 |
number (19) |
bigint |
bigint |
bigint |
decimal(19,0) |
interrogation du driver |
bigint |
non géré |
bigint |
BOOL |
non géré |
non géré |
non géré |
non géré |
non géré |
non géré |
non géré |
non géré |
non géré |
DATE |
date |
date |
date |
date |
datetime |
interrogation du driver |
date |
date |
date |
TIME |
date |
time |
time |
time |
datetime |
interrogation du driver |
time |
time |
time |
TIMESTAMP |
timestamp |
timestamp |
timestamp |
timestamp |
datetime |
interrogation du driver |
datetime2 |
non géré |
timestamp |
IMAGE |
blob* |
longblob |
bytea |
blob (1G) |
image |
interrogation du driver |
varbinary(max) |
non géré |
blob |