Microsoft SQL Server

Datatypes

Scramble

Shuffle

Blank

First day in month

First day in year

Lookup functions

Expression

BIGINT

X

X

X



X

X

BINARY



X



X

X

BIT


X

X



X

X

CHAR

X

X

X



X

X

DATE


X

X

X

X

X

X

DATETIME


X

X

X

X

X

X

DATETIME2


X

X

X

X

X

X

DECIMAL

X

X

X



X

X

FLOAT


X

X



X

X

IMAGE



X



X

X

INT

X

X

X


X

X

INTEGER

X

X

X



X

X

MONEY


X

X



X

X

NCHAR

X

X

X



X

X

NTEXT


X

X



X

X

NUMERIC

X

X

X



X

X

NVARCHAR

X

X

X



X

X

REAL


X

X



X

X

SMALLDATETIME


X

X

X

X

X

X

SMALLINT

X

X

X



X

X

SMALLMONEY


X

X



X

X

SQL_VARIANT







X

TEXT



X




X

TIME


X

X



X

X

TIMESTAMP







X

TINYINT

X

X

X



X

X

UNIQUEIDENTIFIER







X

VARBINARY



X



X

X

VARCHAR

X

X

X



X

X

XML



X



X

X




Oracle RDBMS

Datatypes

Scramble

Shuffle

Blank

First day in month

First day in year

Lookup functions

Expression

BFILE



X




X

BINARY_DOUBLE



X




X

BINARY_FLOAT



X




X

BLOB



X




X

CHAR

X

X

X



X

X

CLOB



X




X

DATE


X

X

X

X

X

X

FLOAT


X

X




X

INTEGER

X

X

X



X

X

LONG







X

LONG RAW







X

MLSLABEL







X

NCHAR

X

X

X



X

X

NCLOB



X




X

NUMBER

X

X

X



X

X

NVARCHAR2

X

X

X



X

X

RAW



X




X

ROWID







X

SDO_GEOMETRY







X

TIMESTAMP


X

X

X

X

X

X

UROWID







X

VARCHAR2

X

X

X



X

X

XMLTYPE



X




X





DB2 LUW

Datatypes

Scramble

Shuffle

Blank

First day in month

First day in year

Lookup functions

Expression

BIGINT

X

X

X



X

X

BINARY LARGE OBJECT



X




X

BLOB



X




X

CHARACTER

X

X

X



X

X

CHARACTER LARGE OBJECT



X




X

CHARACTER VARYING

X

X

X



X

X

CLOB



X




X

DATE


X

X

X

X

X

X

DBCLOB



X




X

DECFLOAT


X

X


X

X

DECIMAL

X

X

X



X

X

DOUBLE


X

X



X

X

DOUBLE PRECISION



X



X

X

GRAPHIC


X

X



X

X

INT

X

X

X



X

X

INTEGER

X


X



X

X

LONG VARCHAR

X

X

X




X

LONG VARGRAPHIC


X

X


X

X

NUMERIC

X

X

X



X

X

REAL


X

X



X

X

SMALLINT

X

X

X



X

X

TIME


X

X



X

X

TIMESTAMP


X

X



X

X

VARCHAR

X

X

X



X

X

VARGRAPHIC


X

X



X

X

XML



X




X





DB2 iSeries

Datatypes

Scramble

Shuffle

Blank

First day in  month

First day in year

Lookup functions

Expression

BIGINT

X

X

X



X

X

BINARY LARGE OBJECT



X




X

BLOB



X




X

CHARACTER

X

X

X



X

X

CHARACTER LARGE OBJECT



X




X

CHARACTER VARYING

X

X

X



X

X

CLOB



X




X

DATE


X

X

X

X

X

X

DBCLOB



X




X

DECFLOAT


X

X



X

X

DECIMAL

X

X

X



X

X

DOUBLE


X

X



X

X

DOUBLE PRECISION



X



X

X

GRAPHIC


X

X



X

X

INT

X

X

X



X

X

INTEGER

X


X



X

X

LONG VARCHAR

X

X

X




X

LONG VARGRAPHIC


X

X



X

X

NUMERIC

X

X

X



X

X

REAL


X

X



X

X

SMALLINT

X

X

X



X

X

TIME


X

X



X

X

TIMESTAMP


X

X


X

X

VARCHAR

X

X

X



X

X

VARGRAPHIC


X

X



X

X

XML



X




X




PostgreSQL

Datatypes

Scramble

Shuffle

Blank

First day in month

First day in year

Lookup functions

Expression

BIGINT

X

X

X



X

X

BIGSERIAL



X




X

BIT



X




X

BIT VARYING



X




X

BOOLEAN



X




X

BOX



X




X

BYTEA



X




X

CHAR

X

X

X



X

X

CHARACTER

X

X

X



X

X

CHARACTER VARYING

X

X

X



X

X

CIDR



X




X

CIRCLE



X




X

DATE


X

X

X

X

X

X

DECIMAL

X

X

X



X

X

DOUBLE_PRECISION

X

X

X



X

X

FLOAT4

X

X

X



X

X

INET



X




X

INT

X

X

X



X

X

INT2

X

X

X



X

X

INT4

X

X

X



X

X

INT8

X

X

X



X

X

INTEGER

X

X

X


X

X

INTERVAL



X




X

JSON



X




X

LINE



X




X

LSEG



X




X

MACADDR



X




X

MONEY



X




X

NUMERIC

X

X

X



X

X

PATH



X




X

POINT



X




X

POLYGON



X




X

REAL

X

X

X



X

X

SERIAL



X




X

SMALLINT

X

X

X



X

X

SMALLSERIAL



X




X

TEXT

X

X

X



X

X

TIME



X




X

TIMESTAMP


X

X

X

X

X

X

TIMESTAMP WITHOUT TIMEZONE


X

X

X

X

X

X

TSQUERY



X




X

TSVECTOR



X




X

TXID_SNAPSHOT



X




X

UUID



X




X

VARCHAR

X

X

X



X

X

XML



X




X