Correspondence Between Adelia Types and Databases

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 or packed)	numerical (extended or packed)
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

↑ Top of page

Correspondence Between Adelia Types and Databases

ALPHA(x)

(variable)