Appendix A: Data Type Mapping for SQL Connection

See the tables below for database to Synergy type mapping for SQL Server, Oracle, and MySQL

SQL Server

Any SQL Server data type not listed below is returned as a Synergy alpha.

Database type	Synergy type
INT	i or d
TINYINT	i or d
SMALLINT	i or d
BIGINT	i or d
REAL	d.
FLOAT	d.
BIT	i or d
DECIMAL	i or d or d.
NUMERIC	i or d or d.
MONEY	i or d or d.
DATE	See Converting dates and times.
TIME	See Converting dates and times.
DATETIME2	See Converting dates and times.
TIMESTAMP	See Converting dates and times.
NCHAR	a or string
VARCHAR	a or string
VARCHAR(MAX)	a or string or %SSC_LARGECOL if greater than 65,535 bytes
NVARCHAR(MAX)	a or string or %SSC_LARGECOL if greater than 65,535 bytes
BINARY	a
VARBINARY	a
VARBINARY(MAX)	a or %SSC_LARGECOL if greater than 65,535 bytes
SS_UDT	a
XML	a or string

Oracle

Database type	Synergy type
CHAR	a or string
NCHAR	a or string
VARCHAR2	a or string
NVARCHAR2	a or string
ROWID	a
ROWID descriptor	a
LONG	i or d
NUMBER	i or d or d.
BLOB	a or %SSC_LARGECOL if greater than 65,535 bytes
CLOB	a or %SSC_LARGECOL if greater than 65,535 bytes
NCLOB	a or %SSC_LARGECOL if greater than 65,535 bytes
RAW	a
LONG RAW	a or %SSC_LARGECOL if greater than 65,535 bytes
DATE	See Converting dates and times.
TIMESTAMP	See Converting dates and times.
TIMESTAMP WITH TZ	See Converting dates and times.

MySQL

Database type	Synergy type
INT	i or d
TINYINT	i or d
SMALLINT	i or d
BIGINT	i or d
FLOAT	d.
DOUBLE	d.
DECIMAL	i or d or d.
NUMERIC	i or d or d.
BIT	i
DATETIME	See Converting dates and times.
TIMESTAMP	See Converting dates and times.
DATE	See Converting dates and times.
TIME	See Converting dates and times.
YEAR	See Converting dates and times.
BLOB	%SSC_LARGECOL
TINY_BLOB	a
MEDIUM_BLOB	a or %SSC_LARGECOL if greater than 65,535 bytes
NULL	a
CHAR	a or string
VARCHAR	a or string
TEXT	a or string or %SSC_LARGECOL if greater than 65,535 bytes
ENUM	a
BINARY	a
VARBINARY	a or string or %SSC_LARGECOL if greater than 65,535 bytes