Data Type Mappings

Kodda automatically maps datatype from source to target systems.

• To manage all of the possible combinations Data Store Data Types are mapped to a standard Type (see Table 1)

• Standard Data Types are then mapped back to Target Data Store Data Types (see Table 2)

The tables below how all of the standard transformation and supported types

Table 1 (Data Store -> Standard Data Type)

Data Store	Data Store Type	Standard Data Type
Delimited File	Datetime	DATETIME
Delimited File	Timestamp	TIMESTAMP WITHOUT TIMEZONE
Delimited File	Decimal	DECIMAL
Delimited File	Integer	INTEGER
Delimited File	Long	BIGINT
Delimited File	String	NATIONAL CHARACTER VARYING
Delimited File	Date/time types	DATE
SQL Server	binary	BINARY
SQL Se rver	image	BINARY
SQL Server	timestamp	TIMESTAMP WITHOUT TIMEZONE
SQL Server	varbinary	BINARY VARYING
SQL Server	date	DATE
SQL Server	datetime	TIMESTAMP WITHOUT TIMEZONE
SQL Server	datetime2	TIMESTAMP WITHOUT TIMEZONE
SQL Server	datetimeoffset	TIMEST AMP WITH TIMEZONE
SQL Server	smalldatetime	DATETIME
SQL Server	time	TIME WITHOUT TIMEZONE
SQL Server	bigint	BIGINT
SQL Server	bit	BOOLEAN
SQL Server	decimal	DECIMAL
SQL Server	float	FLOAT
SQL Server	int	INTEGER
SQL Server	money	DECIMAL
SQL Server	numeric	NUMERIC
SQL Server	real	FLOAT
SQL Server	smallint	SMALLINT
SQL Server	smallmoney	DECIMAL
SQL Server	tinyint	NUMERIC
SQL Server	char	CHARACTER
SQL Server	nchar	NATIONAL CHARACTER
SQL Server	ntext	NATIONAL CHARACTER VARYING LARGE OBJECT
SQL S erver	nvarchar	NATIONAL CHARACTER VARYING
SQL Server	text	CHARACTER VARYING LARGE OBJECT
SQL Server	uniqueidentifier	CHARACTER
SQL Server	varchar	CHARACTER VARYING
SQL Server	xml	XML
SQL Server	sql_variant	CHARACTER VARYING
Oracle	ANYDATA	CHARACTER V ARYING
Oracle	ANYDATASET	CHARACTER VARYING
Oracle	ANYTYPE	CHARACTER VARYING
Oracle	LONG_RAW	BINARY LARGE OBJECT
Oracle	RAW	BINARY VARYING
Oracle	DATE	DATETIME
Oracle	INTERVAL DAY TO SECOND	CHARACTER VARYING
Oracle	INTERVAL YEAR TO MONTH	CHARACTER VA RYING
Oracle	TIMESTAMP	TIMESTAMP WITHOUT TIMEZONE
Oracle	TIMESTAMP WITH LOCAL TIME ZONE	TIMESTAMP WITH TIMEZONE
Oracle	TIMESTAMP WITH TIME ZONE	TIMESTAMP WITH TIMEZONE
Oracle	BFILE	BINARY LARGE OBJECT
Oracle	BLOB	BINARY LARGE OBJECT
Oracle	CLOB	CHARA CTER VARYING LARGE OBJECT
Oracle	NCLOB	NATIONAL CHARACTER VARYING LARGE OBJECT
Oracle	BINARY_DOUBLE	DOUBLE PRECISION
Oracle	BINARY_FLOAT	REAL
Oracle	NUMBER	NUMERIC
Oracle	FLOAT	FLOAT
Oracle	CHAR	CHARACTER
Oracle	LONG	CHARACTER VARYING LARGE OBJECT
Oracle	NCHAR	NATIONAL CHARACTER
Oracle	NVARCHAR2	NATIONAL CHARACTER VARYING
Oracle	VARCHAR2	CHARACTER VARYING
Oracle	ROWID	CHARACTER VARYING
Oracle	UROWID	CHARACTER VARYING
Oracle	HTTPURIType	CHARACTER VARYING
Oracle	URIType	CHARACTER VARYING
Oracle	XDBURIType	CHARACTER VARYING
Oracle	XMLType	XML
Hive	ARRAY	CHARACTER VARYING LARGE OBJECT
Hive	MAP	CHARACTER VARYING LARGE OBJECT
Hive	STRUCT	CHARACTER VARYING LARGE OBJECT
Hive	UNIONTYPE	CHARACTER VARYING LARGE OBJECT
Hive	DATE	DATE
Hive	INTERVAL	CHARACTER VARYING
Hive	TIMESTAMP	TIMESTAMP WITHOUT TIMEZONE
Hive	BINARY	BINARY LARGE OBJECT
Hive	BOOLEAN	BOOLEAN
Hive	BIGINT	BIGINT
Hive	DECIMAL	DECIMAL
Hive	DOUBLE	DOUBLE PRECISION
Hive	FLOAT	FLOAT
Hive	INT	INTEGER
Hive	SMALLINT	SMALLINT
Hive	TI NYINT	SMALLINT
Hive	CHAR	CHARACTER
Hive	STRING	CHARACTER VARYING
Hive	VARCHAR	CHARACTER VARYING
PostgreSQL	bigint	BIGINT
PostgreSQL	bigserial	BIGINT
PostgreSQL	bit	CHARACTER
PostgreSQL	bit varying	CHARACTER VARYING
PostgreSQL	boolean	BOOLEAN
Postg reSQL	box	CHARACTER VARYING
PostgreSQL	bytea	BINARY LARGE OBJECT
PostgreSQL	char	NATIONAL CHARACTER
PostgreSQL	character	NATIONAL CHARACTER
PostgreSQL	character varying	NATIONAL CHARACTER VARYING
PostgreSQL	cidr	CHARACTER VARYING
PostgreSQL	circle	CH ARACTER VARYING
PostgreSQL	date	DATE
PostgreSQL	double precision	DOUBLE PRECISION
PostgreSQL	inet	CHARACTER VARYING
PostgreSQL	integer	INTEGER
PostgreSQL	interval	CHARACTER VARYING
PostgreSQL	interval day to hour	CHARACTER VARYING
PostgreSQL	interva l day to minute	CHARACTER VARYING
PostgreSQL	interval day to second	CHARACTER VARYING
PostgreSQL	interval hour to minute	CHARACTER VARYING
PostgreSQL	interval hour to second	CHARACTER VARYING
PostgreSQL	interval minute to second	CHARACTER VARYING
Post greSQL	interval year to month	CHARACTER VARYING
PostgreSQL	json	NATIONAL CHARACTER VARYING LARGE OBJECT
PostgreSQL	jsonb	BINARY LARGE OBJECT
PostgreSQL	line	CHARACTER VARYING
PostgreSQL	lseg	CHARACTER VARYING
PostgreSQL	macaddr	CHARACTER VARYING
Post greSQL	money	NUMERIC
PostgreSQL	numeric	NUMERIC
PostgreSQL	path	CHARACTER VARYING
PostgreSQL	pg_lsn	CHARACTER VARYING
PostgreSQL	point	CHARACTER VARYING
PostgreSQL	polygon	CHARACTER VARYING
PostgreSQL	real	REAL
PostgreSQL	serial	INTEGER
PostgreSQL	smallint	SMALLINT
PostgreSQL	smallserial	SMALLINT
PostgreSQL	text	NATIONAL CHARACTER VARYING
PostgreSQL	time with time zone	TIME WITH TIMEZONE
PostgreSQL	time without time zone	TIME WITHOUT TIMEZONE
PostgreSQL	timestamp with time zone	TIMESTAMP WITH T IMEZONE
PostgreSQL	timestamp without time zone	TIMESTAMP WITHOUT TIMEZONE
PostgreSQL	tsquery	NATIONAL CHARACTER VARYING
PostgreSQL	tsvector	NATIONAL CHARACTER VARYING
PostgreSQL	txid_snapshot	NATIONAL CHARACTER VARYING
PostgreSQL	unknown	NATIONAL CHAR ACTER VARYING
PostgreSQL	uuid	CHARACTER
PostgreSQL	xml	XML
Snowflake	NUMBER	NUMERIC
Snowflake	DECIMAL	DECIMAL
Snowflake	NUMERIC	NUMERIC
Snowflake	INT	INTEGER
Snowflake	INTEGER	INTEGER
Snowflake	BIGINT	BIGINT
Snowflake	SMALLINT	SMALLINT
Snowflake	BYTEINT	INTEGER
Snowflake	TINYINT	INTEGER
Snowflake	FLOAT	DOUBLE PRECISION
Snowflake	FLOAT4	DOUBLE PRECISION
Snowflake	FLOAT8	DOUBLE PRECISION
Snowflake	DOUBLE	DOUBLE PRECISION
Snowflake	DOUBLE PRECISION	DOUBLE PRECISION
Snowflake	REAL	DOUBLE PRECIS ION
Snowflake	VARCHAR	NATIONAL CHARACTER VARYING
Snowflake	CHAR	NATIONAL CHARACTER
Snowflake	CHARACTER	NATIONAL CHARACTER
Snowflake	STRING	NATIONAL CHARACTER VARYING
Snowflake	TEXT	NATIONAL CHARACTER VARYING
Snowflake	BINARY	BINARY
Snowflake	VARBINA RY	BINARY VARYING
Snowflake	BOOLEAN	BOOLEAN
Snowflake	DATE	DATE
Snowflake	DATETIME	TIMESTAMP WITHOUT TIMEZONE
Snowflake	TIME	TIME WITHOUT TIMEZONE
Snowflake	TIMESTAMP_LTZ	TIMESTAMP WITH TIMEZONE
Snowflake	TIMESTAMP_NTZ	TIMESTAMP WITHOUT TIMEZONE
Sno wflake	TIMESTAMP_TZ	TIMESTAMP WITH TIMEZONE
Snowflake	OBJECT	CHARACTER VARYING LARGE OBJECT
Snowflake	ARRAY	CHARACTER VARYING LARGE OBJECT
Snowflake	VARIANT	CHARACTER VARYING LARGE OBJECT
Redshift	bigint	BIGINT
Redshift	int8	BIGINT
Redshift	boolean	B OOLEAN
Redshift	char	NATIONAL CHARACTER
Redshift	character	NATIONAL CHARACTER
Redshift	character varying	NATIONAL CHARACTER VARYING
Redshift	bpchar	NATIONAL CHARACTER
Redshift	nvarchar	NATIONAL CHARACTER VARYING
Redshift	varchar	NATIONAL CHARACTER VA RYING
Redshift	date	DATE
Redshift	double precision	DOUBLE PRECISION
Redshift	float8	DOUBLE PRECISION
Redshift	float	DOUBLE PRECISION
Redshift	integer	INTEGER
Redshift	int4	INTEGER
Redshift	decimal	NUMERIC
Redshift	numeric	NUMERIC
Redshift	float4	R EAL
Redshift	real	REAL
Redshift	smallint	SMALLINT
Redshift	int2	SMALLINT
Redshift	text	NATIONAL CHARACTER VARYING
Redshift	timestamp with time zone	TIMESTAMP WITH TIMEZONE
Redshift	timestamp without time zone	TIMESTAMP WITHOUT TIMEZONE
Redshift	unkn own	NATIONAL CHARACTER VARYING
MySQL	binary	BINARY
MySQL	varbinary	BINARY VARYING
MySQL	boolean	BOOLEAN
MySQL	date	DATE
MySQL	datetime	TIMESTAMP WITHOUT TIMEZONE
MySQL	timestamp	TIMESTAMP WITHOUT TIMEZONE
MySQL	time	TIME WITHOUT TIMEZONE
MySQL	year	SMALLINT
MySQL	geometry	CHARACTER VARYING
MySQL	point	CHARACTER VARYING
MySQL	linestring	CHARACTER VARYING
MySQL	polygon	CHARACTER VARYING
MySQL	multipoint	CHARACTER VARYING
MySQL	multilinestring	CHARACTER VARYING
MySQL	multipolygon	CHARACTER VARYI NG
MySQL	geometrycollection	CHARACTER VARYING
MySQL	tinyblob	BINARY LARGE OBJECT
MySQL	blob	BINARY LARGE OBJECT
MySQL	mediumblob	BINARY LARGE OBJECT
MySQL	longblob	BINARY LARGE OBJECT
MySQL	longtext	NATIONAL CHARACTER VARYING LARGE OBJECT
MySQL	bit	BINARY
MySQL	tinyint	SMALLINT
MySQL	smallint	SMALLINT
MySQL	mediumint	INTEGER
MySQL	int	INTEGER
MySQL	integer	INTEGER
MySQL	decimal	DECIMAL
MySQL	numeric	NUMERIC
MySQL	bigint	BIGINT
MySQL	float	FLOAT
MySQL	double	DOUBLE PRECISION
MySQL	double pr ecision	DOUBLE PRECISION
MySQL	real	FLOAT
MySQL	bool	BOOLEAN
MySQL	char	CHARACTER
MySQL	tinytext	NATIONAL CHARACTER VARYING
MySQL	text	NATIONAL CHARACTER VARYING
MySQL	mediumtext	NATIONAL CHARACTER VARYING LARGE OBJECT
MySQL	varchar	NATIONAL CHARACT ER VARYING
MySQL	enum	NATIONAL CHARACTER VARYING LARGE OBJECT
MySQL	set	NATIONAL CHARACTER VARYING LARGE OBJECT
MySQL	json	NATIONAL CHARACTER VARYING LARGE OBJECT

Table 2 ( Standard Data Type -> Data Store)

Standard Data Type	Data Store	Data Store Type
INTEGER	Delimited File	String
SMALLINT	Delimited File	String
BIGINT	Delimited File	String
NUMERIC	Delimited File	String
DECIMAL	Delimited File	String
REAL	Delimited File	String
DOUBLE PRECISION	Delimited File	String
FLOAT	Delimited File	String
BIN ARY	Delimited File	String
BINARY VARYING	Delimited File	String
BINARY LARGE OBJECT	Delimited File	String
BOOLEAN	Delimited File	String
CHARACTER	Delimited File	String
CHARACTER VARYING	Delimited File	String
CHARACTER VARYING LARGE OBJECT	Delimited Fi le	String
NATIONAL CHARACTER	Delimited File	String
NATIONAL CHARACTER VARYING	Delimited File	String
NATIONAL CHARACTER VARYING LARGE OBJECT	Delimited File	String
DATE	Delimited File	String
TIME WITHOUT TIMEZONE	Delimited File	String
TIMESTAMP WITHOUT TIMEZONE	Delimited File	String
TIME WITH TIMEZONE	Delimited File	String
TIMESTAMP WITH TIMEZONE	Delimited File	String
INTERVAL DAY	Delimited File	String
INTERVAL YEAR	Delimited File	String
ARRAY	Delimited File	String
MULTISET	Delimited File	String
ROW	Delimited File	String
XML	Delimited File	String
DATETIME	Delimited File	String
INTEGER	PostgreSQL	integer
SMALLINT	PostgreSQL	smallint
BIGINT	PostgreSQL	bigint
NUMERIC	PostgreSQL	numeric
DECIMAL	PostgreSQL	numeric
REAL	PostgreSQL	real
DOUBLE P RECISION	PostgreSQL	double precision
FLOAT	PostgreSQL	real
BINARY	PostgreSQL	bytea
BINARY VARYING	PostgreSQL	bytea
BINARY LARGE OBJECT	PostgreSQL	bytea
BOOLEAN	PostgreSQL	boolean
CHARACTER	PostgreSQL	character
CHARACTER VARYING	PostgreSQL	character varying
CHARACTER VARYING LARGE OBJECT	PostgreSQL	text
NATIONAL CHARACTER	PostgreSQL	character
NATIONAL CHARACTER VARYING	PostgreSQL	character varying
NATIONAL CHARACTER VARYING LARGE OBJECT	PostgreSQL	text
DATE	PostgreSQL	date
TIME WITHOUT TIMEZONE	PostgreSQL	time without time zone
TIMESTAMP WITHOUT TIMEZONE	PostgreSQL	timestamp without time zone
TIME WITH TIMEZONE	PostgreSQL	time with time zone
TIMESTAMP WITH TIMEZONE	PostgreSQL	timestamp with time zone
INTERVAL DAY	PostgreSQL	character varying
INTERVAL YEAR	PostgreSQL	character varying
ARRAY	PostgreSQL	text
MULTISET	PostgreSQL	text
ROW	PostgreSQL	text
XML	PostgreSQL	xml
DATETIME	PostgreSQL	timestamp without time zone
INTEGER	Oracle	NUMBER
SMALLINT	Oracle	NUMBER
BIGINT	Oracle	NUMBER
NUM ERIC	Oracle	NUMBER
DECIMAL	Oracle	NUMBER
REAL	Oracle	FLOAT
DOUBLE PRECISION	Oracle	FLOAT
FLOAT	Oracle	FLOAT
BINARY	Oracle	RAW
BINARY VARYING	Oracle	RAW
BINARY LARGE OBJECT	Oracle	BLOB
BOOLEAN	Oracle	CHAR
CHARACTER	Oracle	CHAR
CHARACTER VARYING	Or acle	VARCHAR2
CHARACTER VARYING LARGE OBJECT	Oracle	CLOB
NATIONAL CHARACTER	Oracle	CHAR
NATIONAL CHARACTER VARYING	Oracle	VARCHAR2
NATIONAL CHARACTER VARYING LARGE OBJECT	Oracle	CLOB
DATE	Oracle	DATE
TIME WITHOUT TIMEZONE	Oracle	VARCHAR2
TIMESTAMP W ITHOUT TIMEZONE	Oracle	TIMESTAMP
TIME WITH TIMEZONE	Oracle	VARCHAR2
TIMESTAMP WITH TIMEZONE	Oracle	TIMESTAMP WITH TIME ZONE
INTERVAL DAY	Oracle	VARCHAR2
INTERVAL YEAR	Oracle	VARCHAR2
ARRAY	Oracle	VARCHAR2
MULTISET	Oracle	VARCHAR2
ROW	Oracle	VARCHAR2
XML	Oracle	XMLType
DATETIME	Oracle	DATE
INTEGER	Hive	INT
SMALLINT	Hive	SMALLINT
BIGINT	Hive	BIGINT
NUMERIC	Hive	DECIMAL
DECIMAL	Hive	DECIMAL
REAL	Hive	FLOAT
DOUBLE PRECISION	Hive	DOUBLE
FLOAT	Hive	FLOAT
BINARY	Hive	BINARY
BINARY VARYING	Hive	B INARY
BINARY LARGE OBJECT	Hive	BINARY
BOOLEAN	Hive	BOOLEAN
CHARACTER	Hive	CHAR
CHARACTER VARYING	Hive	VARCHAR
CHARACTER VARYING LARGE OBJECT	Hive	STRING
NATIONAL CHARACTER	Hive	CHAR
NATIONAL CHARACTER VARYING	Hive	VARCHAR
NATIONAL CHARACTER VARYING LARGE OBJECT	Hive	STRING
DATE	Hive	DATE
TIME WITHOUT TIMEZONE	Hive	VARCHAR
TIMESTAMP WITHOUT TIMEZONE	Hive	TIMESTAMP
TIME WITH TIMEZONE	Hive	VARCHAR
TIMESTAMP WITH TIMEZONE	Hive	TIMESTAMP
INTERVAL DAY	Hive	VARCHAR
INTERVAL YEAR	Hive	VARCHAR
ARRAY	Hive	STRING
MULTISET	Hive	STRING
ROW	Hive	STRING
XML	Hive	STRING
DATETIME	Hive	TIMESTAMP
INTEGER	SQL Server	int
SMALLINT	SQL Server	smallint
BIGINT	SQL Server	bigint
NUMERIC	SQL Server	numeric
DECIMAL	SQL Server	decimal
REAL	SQL Server	real
DOUB LE PRECISION	SQL Server	float
FLOAT	SQL Server	real
BINARY	SQL Server	binary
BINARY VARYING	SQL Server	varbinary
BINARY LARGE OBJECT	SQL Server	varbinary
BOOLEAN	SQL Server	varchar
CHARACTER	SQL Server	char
CHARACTER VARYING	SQL Server	varchar
CHAR ACTER VARYING LARGE OBJECT	SQL Server	varchar
NATIONAL CHARACTER	SQL Server	nchar
NATIONAL CHARACTER VARYING	SQL Server	nvarchar
NATIONAL CHARACTER VARYING LARGE OBJECT	SQL Server	nvarchar
DATE	SQL Server	date
TIME WITHOUT TIMEZONE	SQL Server	time
TI MESTAMP WITHOUT TIMEZONE	SQL Server	datetime2
TIME WITH TIMEZONE	SQL Server	time
TIMESTAMP WITH TIMEZONE	SQL Server	datetimeoffset
INTERVAL DAY	SQL Server	varchar
INTERVAL YEAR	SQL Server	varchar
ARRAY	SQL Server	varchar
MULTISET	SQL Server	varchar
ROW	SQL Server	varchar
XML	SQL Server	xml
DATETIME	SQL Server	datetime2
INTEGER	Snowflake	INT
SMALLINT	Snowflake	SMALLINT
BIGINT	Snowflake	BIGINT
NUMERIC	Snowflake	NUMERIC
DECIMAL	Snowflake	DECIMAL
REAL	Snowflake	DOUBLE
DOUBLE PRECISION	Snowflake	DOUBLE
FLOAT	Snowflake	DOUBLE
BINARY	Snowflake	VARCHAR
BINARY VARYING	Snowflake	VARCHAR
BINARY LARGE OBJECT	Snowflake	VARCHAR
BOOLEAN	Snowflake	BOOLEAN
CHARACTER	Snowflake	CHAR
CHARACTER VARYING	Snowflake	VARCHAR
CHARACTER VARYING LARGE OBJECT	Snow flake	VARCHAR
NATIONAL CHARACTER	Snowflake	CHAR
NATIONAL CHARACTER VARYING	Snowflake	VARCHAR
NATIONAL CHARACTER VARYING LARGE OBJECT	Snowflake	VARCHAR
DATE	Snowflake	DATE
TIME WITHOUT TIMEZONE	Snowflake	TIME
TIMESTAMP WITHOUT TIMEZONE	Snowflake	TIMES TAMP_NTZ
TIME WITH TIMEZONE	Snowflake	VARCHAR
TIMESTAMP WITH TIMEZONE	Snowflake	TIMESTAMP_TZ
INTERVAL DAY	Snowflake	VARCHAR
INTERVAL YEAR	Snowflake	VARCHAR
ARRAY	Snowflake	VARCHAR
MULTISET	Snowflake	VARCHAR
ROW	Snowflake	VARCHAR
XML	Snowflake	VARCH AR
DATETIME	Snowflake	TIMESTAMP_NTZ
INTEGER	Redshift	integer
SMALLINT	Redshift	smallint
BIGINT	Redshift	bigint
NUMERIC	Redshift	decimal
DECIMAL	Redshift	decimal
REAL	Redshift	real
DOUBLE PRECISION	Redshift	double precision
FLOAT	Redshift	real
BIN ARY	Redshift	text
BINARY VARYING	Redshift	text
BINARY LARGE OBJECT	Redshift	text
BOOLEAN	Redshift	boolean
CHARACTER	Redshift	char
CHARACTER VARYING	Redshift	varchar
CHARACTER VARYING LARGE OBJECT	Redshift	text
NATIONAL CHARACTER	Redshift	char
NATIO NAL CHARACTER VARYING	Redshift	varchar
NATIONAL CHARACTER VARYING LARGE OBJECT	Redshift	text
DATE	Redshift	date
TIME WITHOUT TIMEZONE	Redshift	varchar
TIMESTAMP WITHOUT TIMEZONE	Redshift	timestamp without time zone
TIME WITH TIMEZONE	Redshift	varchar
TIMESTAMP WITH TIMEZONE	Redshift	timestamp with time zone
INTERVAL DAY	Redshift	varchar
INTERVAL YEAR	Redshift	varchar
ARRAY	Redshift	text
MULTISET	Redshift	text
ROW	Redshift	text
XML	Redshift	text
DATETIME	Redshift	timestamp
INTEGER	MySQL	integer
SMALLINT	MySQL	smallint
BIGINT	MySQL	bigint
NUMERIC	MySQL	numeric
DECIMAL	MySQL	decimal
REAL	MySQL	real
DOUBLE PRECISION	MySQL	double precision
FLOAT	MySQL	float
BINARY	MySQL	binary
BINARY VARYING	MySQL	varbinary
BINARY LARGE OBJECT	MySQL	blob
BOOLEAN	MySQL	boolean
CHARACTER	MySQL	char
CHARACTER VARYING	MySQL	varchar
CHARACTER VARYING LARGE OBJECT	MySQL	text
NATIONAL CHARACTER	MySQL	char
NATIONAL CHARACTER VARYING	MySQL	varchar
NATIONAL CHARACTER VARYING LARGE OBJECT	MySQL	text
DATE	MySQL	date
TIME WITHOUT TIMEZONE	MySQL	time
TIMESTAMP WITHOUT TIMEZONE	MySQL	timestamp
TIME WITH TIMEZONE	MySQL	time
TIMESTAMP WITH TIMEZONE	MySQL	timestamp
INTERVAL DAY	MySQL	varchar
INTERVAL YEAR	MySQL	varchar
ARRAY	MySQL	text
MULTISET	MySQL	text
ROW	MySQL	text
XML	MySQL	text
DATETIME	MySQL	datetime