Type Adélia |
Type Oracle |
Type MySQL |
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 |
si x <= 254 char(x) si x <= 3098 varchar(x) si x > 3098 long varchar |
si x <= 255 char(x) si x > 255 memo |
interrogation du driver |
si x <= 8000 char(x) si x > 8000 text |
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 |
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 text |
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 |
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 ntext |
-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 |
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 ntext |
-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)
|
decimal(x, y) |
double |
interrogation du driver |
numeric(x,y)
|
numérique (étendu |
numérique (étendu
|
NUM_BIN_2 |
number (5)
|
smallint
|
smallint |
smallint |
interrogation du driver
|
smallint
|
bin2
|
binaire(4.0)
|
NUM_BIN_4 |
number (10)
|
int
|
integer
|
int |
interrogation du driver
|
integer
|
bin4
|
binaire(9.0) |
NUM_BIN_8 |
number (19)
|
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é |
DATE |
date
|
date
|
date |
datetime |
interrogation du driver
|
datetime
|
date
|
date
|
TIME |
date
|
time
|
time |
datetime |
interrogation du driver
|
datetime
|
time
|
time
|
TIMESTAMP |
date
|
timestamp
|
timestamp |
datetime |
interrogation du driver
|
datetime
|
non géré
|
timestamp |
IMAGE |
blob* |
longblob
|
blob (1G) |
image |
interrogation du driver |
image
|
non géré |
blob |