|
|
SQL Server |
PostgreSQL |
MySQL |
Informix |
DB2 for iSeries |
Oracle |
DB2 Universal |
|
Character(n) |
char(n) |
CHAR(n) |
char(n) |
CHAR(n) |
CHAR(n) |
CHAR(n) |
CHAR(n) |
|
VARCHAR(n) n > 254 | |||||||
|
Character(n) Enable NLS |
nchar(n) |
CHAR(n) |
national char(n) |
CHAR(n) |
GRAPHIC(n) CCSID 13488 |
NCHAR(n) |
GRAPHIC(n) n < 128 |
|
VARGRAPHIC(n) | |||||||
|
Boolean |
BIT |
BOOLEAN |
BOOL |
BOOLEAN |
DECIMAL( 1) |
NUMERIC(1) |
NUMERIC(1) |
|
Blob |
VARBINARY(MAX)
Version = 2005 |
BYTEA |
LONGBLOB |
BYTE |
BLOB |
BLOB |
BLOB( 2G) NOT LOGGED |
|
IMAGE | |||||||
|
Date |
datetime |
date |
date |
DateTime Year to Day |
CHAR(8) |
DATE |
DATE |
|
DateTime |
datetime |
timestamp without time zone |
datetime |
DateTime Year to Second |
TIMESTAMP |
DATE |
TIMESTAMP |
|
GUID |
uniqueidentifier |
CHAR(36) |
CHAR(36) |
CHAR(36) |
CHAR(36) |
CHAR(36) |
CHAR(36) |
|
VarChar(n) |
varchar(n) |
VARCHAR(n) |
varchar(n) |
varchar(n) |
varchar(n) |
VARCHAR(n) |
VARCHAR(n) |
|
varchar(n, a) |
VARCHAR2(n) Declare varchar as varchar2 | ||||||
|
VarChar (n) Enable NLS |
nvarchar(n) |
VARCHAR(n) |
national varchar(n) |
varchar(n) |
varchar(n) |
VARCHAR(n) |
VARGRAPHIC(n) |
|
varchar(n, a) |
NVARCHAR2(n) Declare varchar as varchar2 | ||||||
|
LongVarChar (n) |
varchar(MAX) Version = 2005 |
TEXT |
TEXT n<65535 |
TEXT |
CLOB |
CLOB |
CLOB(n) |
|
TEXT |
MEDIUMTEXT n<16777215 | ||||||
|
LONGTEXT | |||||||
|
LongVarChar (n) Enable NLS |
NVARCHAR(MAX)Version = 2005 |
TEXT |
TEXT CHARACTER SET utf8 n<65535 |
TEXT |
CLOB |
CLOB |
DBCLOB(n) |
|
NTEXT |
MEDIUMTEXT CHARACTER SET utf8 n<16777215 | ||||||
|
LONGTEXT CHARACTER SET utf8 | |||||||
|
Numeric(L.0) |
smallint L<5 |
smallint L<5 |
smallint L<5 |
SERIAL(s) L<5 Autonumber |
DECIMAL(L) |
NUMERIC(L) |
NUMERIC(L) |
|
int L<10 |
integer L<10 |
mediumint L<7 |
SERIAL8(s) Autonumber | ||||
|
decimal(L) |
bigint L<19 |
int L<10
|
INT L<5 Subtipo de Autonumber | ||||
|
NUMERIC(L) |
bigint L<19 |
INT8 Subtipo de Autonumber | |||||
|
NUMERIC(L) |
SMALLINT L<5 | ||||||
|
INT L<10 | |||||||
|
DECIMAL(L) | |||||||
|
Numeric(L.D) |
smallmoney 0<D<4 L-D-1<6 |
NUMERIC(L-1,D) |
NUMERIC(L-1,D) |
DECIMAL(L-1,D) |
DECIMAL(L-1,D) |
NUMERIC(L-1,D) |
NUMERIC(L-1,D) |
|
money 0<D<4 L-D-1<15 | |||||||
|
decimal(L-1,D)
|