Data Type Mappings

Numeric scale (s) has a range of 0 through 30, but it cannot exceed precision (p). Precision has a range of: 1 through 264 (MySQL 5.0.2 and earlier); 1 through 64 (MySQL 5.0.3 to 5.0.5); or 1 through 65 (MySQL 5.0.6 and later).

MySQL Data Type	TDV Data Type	Notes
BIGINT	BIGINT NUMERIC(20, 0)
BINARY	BINARY
BIT	BIT
BIT(1)	BOOLEAN	MySQL 5.0 override.
BLOB	VARBINARY
BOOL	BOOLEAN	(See Mapping of Native to TDV Data Types Across TDV Versions.)
CHAR	CHAR
DATE	DATE
DATETIME	TIMESTAMP
DEC	DECIMAL
DECIMAL	DECIMAL
DOUBLE	DOUBLE
DOUBLE PRECISION	DOUBLE
DOUBLE UNSIGNED	DOUBLE
ENUM	VARCHAR
FIXED	DECIMAL
FLOAT	DOUBLE
FLOAT UNSIGNED	DOUBLE
INT	INTEGER	Unsigned INT or unsigned INTEGER.
INTEGER	INTEGER
LONGBLOB	BLOB
LONGTEXT	CLOB
MEDIUMBLOB	BLOB
MEDIUMINT	INTEGER
MEDIUMTEXT	CLOB
NUMERIC	DECIMAL
REAL	DOUBLE
SET	VARCHAR
SMALLINT	SMALLINT
TEXT	VARCHAR
TIME	TIME
TIMESTAMP	TIMESTAMP
TINYBLOB	VARBINARY
TINYINT	TINYINT
TINYTEXT	VARCHAR
VARBINARY	VARBINARY
VARCHAR	VARCHAR
YEAR	SMALLINT