Microsoft SQL Server

Datatypes

Scramble

Shuffle

Blank

First day in month

First day in year

Lookup functions

Expression

BIGINT

(tick)

(tick)

(tick)



(tick)

(tick)

BINARY



(tick)



(tick)

(tick)

BIT


(tick)

(tick)



(tick)

(tick)

CHAR

(tick)

(tick)

(tick)



(tick)

(tick)

DATE


(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

DATETIME


(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

DATETIME2


(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

DECIMAL

(tick)

(tick)

(tick)



(tick)

(tick)

FLOAT


(tick)

(tick)



(tick)

(tick)

IMAGE



(tick)



(tick)

(tick)

INT

(tick)

(tick)

(tick)



(tick)

(tick)

INTEGER

(tick)

(tick)

(tick)



(tick)

(tick)

MONEY


(tick)

(tick)



(tick)

(tick)

NCHAR

(tick)

(tick)

(tick)



(tick)

(tick)

NTEXT


(tick)

(tick)



(tick)

(tick)

NUMERIC

(tick)

(tick)

(tick)



(tick)

(tick)

NVARCHAR

(tick)

(tick)

(tick)



(tick)

(tick)

REAL


(tick)

(tick)



(tick)

(tick)

SMALLDATETIME


(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

SMALLINT

(tick)

(tick)

(tick)



(tick)

(tick)

SMALLMONEY


(tick)

(tick)



(tick)

(tick)

SQL_VARIANT







(tick)

TEXT



(tick)




(tick)

TIME


(tick)

(tick)



(tick)

(tick)

TIMESTAMP







(tick)

TINYINT

(tick)

(tick)

(tick)



(tick)

(tick)

UNIQUEIDENTIFIER







(tick)

VARBINARY



(tick)



(tick)

(tick)

VARCHAR

(tick)

(tick)

(tick)



(tick)

(tick)

XML



(tick)



(tick)

(tick)



Oracle RDBMS

Datatypes

Scramble

Shuffle

Blank

First day in month

First day in year

Lookup functions

Expression

BFILE



(tick)




(tick)

BINARY_DOUBLE



(tick)




(tick)

BINARY_FLOAT



(tick)




(tick)

BLOB



(tick)




(tick)

CHAR

(tick)

(tick)

(tick)



(tick)

(tick)

CLOB



(tick)




(tick)

DATE


(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

FLOAT


(tick)

(tick)




(tick)

INTEGER

(tick)

(tick)

(tick)



(tick)

(tick)

LONG







(tick)

LONG RAW







(tick)

MLSLABEL







(tick)

NCHAR

(tick)

(tick)

(tick)



(tick)

(tick)

NCLOB



(tick)




(tick)

NUMBER

(tick)

(tick)

(tick)



(tick)

(tick)

NVARCHAR2

(tick)

(tick)

(tick)



(tick)

(tick)

RAW



(tick)




(tick)

ROWID







(tick)

SDO_GEOMETRY







(tick)

TIMESTAMP


(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

UROWID







(tick)

VARCHAR2

(tick)

(tick)

(tick)



(tick)

(tick)

XMLTYPE



(tick)




(tick)


DB2 LUW

Datatypes

Scramble

Shuffle

Blank

First day in  month

First day in year

Lookup functions

Expression

BIGINT

(tick)

(tick)

(tick)



(tick)

(tick)

BINARY LARGE OBJECT



(tick)




(tick)

BLOB



(tick)




(tick)

CHARACTER

(tick)

(tick)

(tick)



(tick)

(tick)

CHARACTER LARGE OBJECT



(tick)




(tick)

CHARACTER VARYING

(tick)

(tick)

(tick)



(tick)

(tick)

CLOB



(tick)




(tick)

DATE


(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

DBCLOB



(tick)




(tick)

DECFLOAT


(tick)

(tick)



(tick)

(tick)

DECIMAL

(tick)

(tick)

(tick)



(tick)

(tick)

DOUBLE


(tick)

(tick)



(tick)

(tick)

DOUBLE PRECISION



(tick)



(tick)

(tick)

GRAPHIC


(tick)

(tick)



(tick)

(tick)

INT

(tick)

(tick)

(tick)



(tick)

(tick)

INTEGER

(tick)


(tick)



(tick)

(tick)

LONG VARCHAR

(tick)

(tick)

(tick)




(tick)

LONG VARGRAPHIC


(tick)

(tick)



(tick)

(tick)

NUMERIC

(tick)

(tick)

(tick)



(tick)

(tick)

REAL


(tick)

(tick)



(tick)

(tick)

SMALLINT

(tick)

(tick)

(tick)



(tick)

(tick)

TIME


(tick)

(tick)



(tick)

(tick)

TIMESTAMP


(tick)

(tick)



(tick)

(tick)

VARCHAR

(tick)

(tick)

(tick)



(tick)

(tick)

VARGRAPHIC


(tick)

(tick)



(tick)

(tick)

XML



(tick)




(tick)


DB2 iSeries

Datatypes

Scramble

Shuffle

Blank

First day in  month

First day in year

Lookup functions

Expression

BIGINT

(tick)

(tick)

(tick)

-

-

(tick)

(tick)

BINARY LARGE OBJECT

-

-

(tick)

-

-

-

(tick)

BLOB

-

-

(tick)

-

-

-

(tick)

CHARACTER

(tick)

(tick)

(tick)

-

-

(tick)

(tick)

CHARACTER LARGE OBJECT

-

-

(tick)

-

-

-

(tick)

CHARACTER VARYING

(tick)

(tick)

(tick)

-

-

(tick)

(tick)

CLOB

-

-

(tick)

-

-

-

(tick)

DATE

-

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

DBCLOB

-

-

(tick)

-

-

-

(tick)

DECFLOAT

-

(tick)

(tick)

-

-

(tick)

(tick)

DECIMAL

(tick)

(tick)

(tick)

-

-

(tick)

(tick)

DOUBLE

-

(tick)

(tick)

-

-

(tick)

(tick)

DOUBLE PRECISION

-

-

(tick)

-

-

(tick)

(tick)

GRAPHIC

-

(tick)

(tick)

-

-

(tick)

(tick)

INT

(tick)

(tick)

(tick)

-

-

(tick)

(tick)

INTEGER

(tick)

-

(tick)

-

-

(tick)

(tick)

LONG VARCHAR

(tick)

(tick)

(tick)

-

-

-

(tick)

LONG VARGRAPHIC

-

(tick)

(tick)

-

-

(tick)

(tick)

NUMERIC

(tick)

(tick)

(tick)

-

-

(tick)

(tick)

REAL

-

(tick)

(tick)

-

-

(tick)

(tick)

SMALLINT

(tick)

(tick)

(tick)

-

-

(tick)

(tick)

TIME

-

(tick)

(tick)

-

-

(tick)

(tick)

TIMESTAMP

-

(tick)

(tick)

-

-

(tick)

(tick)

VARCHAR

(tick)

(tick)

(tick)

-

-

(tick)

(tick)

VARGRAPHIC

-

(tick)

(tick)

-

-

(tick)

(tick)

XML

-

-

(tick)

-

-

-

(tick)

PostgreSQL

Datatypes

Scramble

Shuffle

Blank

First day in month

First day in year

Lookup functions

Expression

BIGINT

(tick)(tick)(tick)

(tick)(tick)
BIGSERIAL

(tick)


(tick)
BIT

(tick)


(tick)
BIT VARYING

(tick)


(tick)
BOOLEAN

(tick)


(tick)
BOX

(tick)


(tick)
BYTEA

(tick)


(tick)
CHAR(tick)(tick)(tick)

(tick)(tick)
CHARACTER(tick)(tick)(tick)

(tick)(tick)
CHARACTER VARYING(tick)(tick)(tick)

(tick)(tick)
CIDR

(tick)


(tick)
CIRCLE

(tick)


(tick)
DATE
(tick)(tick)(tick)(tick)(tick)(tick)
DECIMAL(tick)(tick)(tick)

(tick)(tick)
DOUBLE_PRECISION(tick)(tick)(tick)

(tick)(tick)
FLOAT4(tick)(tick)(tick)

(tick)(tick)
INET

(tick)


(tick)
INT(tick)(tick)(tick)

(tick)(tick)
INT2(tick)(tick)(tick)

(tick)(tick)
INT4(tick)(tick)(tick)

(tick)(tick)
INT8(tick)(tick)(tick)

(tick)(tick)
INTEGER(tick)(tick)(tick)

(tick)(tick)
INTERVAL

(tick)


(tick)
JSON

(tick)


(tick)
LINE

(tick)


(tick)
LSEG

(tick)


(tick)
MACADDR

(tick)


(tick)
MONEY

(tick)


(tick)
NUMERIC(tick)(tick)(tick)

(tick)(tick)
PATH

(tick)


(tick)
POINT

(tick)


(tick)
POLYGON

(tick)


(tick)
REAL(tick)(tick)(tick)

(tick)(tick)
SERIAL

(tick)


(tick)
SMALLINT(tick)(tick)(tick)

(tick)(tick)
SMALLSERIAL

(tick)


(tick)
TEXT(tick)(tick)(tick)

(tick)(tick)
TIME

(tick)


(tick)
TIMESTAMP
(tick)(tick)(tick)(tick)(tick)(tick)
TIMESTAMP WITHOUT TIMEZONE
(tick)(tick)(tick)(tick)(tick)(tick)
TSQUERY

(tick)


(tick)
TSVECTOR

(tick)


(tick)
TXID_SNAPSHOT

(tick)


(tick)
UUID

(tick)


(tick)
VARCHAR(tick)(tick)(tick)

(tick)(tick)
XML

(tick)


(tick)