Microsoft SQL Server

The following Microsoft SQL Server data types are supported by DataDirect database drivers:

Microsoft SQL Server Data Type	JDBC Data Type
BIGINT Note: Supported only for Microsoft SQL Server 2000 and later versions.	BIGINT
BINARY	BINARY
BIT	BIT
CHAR	CHAR
DATETIME	TIMESTAMP
DECIMAL	DECIMAL
FLOAT	FLOAT
LONGBLOB	LONGVARBINARY
LONGTEXT	LONGVARCHAR
MEDIUMBLOB	LONGVARBINARY
MEDIUMINT	INTEGER
MEDIUMINT UNSIGNED	INTEGER
MEDIUMTEXT	LONGVARCHAR
IMAGE	LONGVARBINARY
INT	INTEGER
MONEY	DECIMAL
NCHAR	CHAR or NCHAR Note: When JDBCBehavior=0, this data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and later versions, the second value applies.
NTEXT	LONGVARCHAR or LONGNVARCHAR Note: Note: When JDBCBehavior=0, this data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and later versions, the second value applies.
NUMERIC	NUMERIC
NVARCHAR	VARCHAR or NVARCHAR Note: When JDBCBehavior=0, this data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and later versions, the second value applies.
REAL	REAL
SMALLDATETIME	TIMESTAMP
SMALLINT	SMALLINT
SMALLMONEY	DECIMAL
TEXT	LONGVARCHAR
TIMESTAMP Note: When Microsoft SQL Server 2012 is used, the adapter does not support the TIMESTAMP data type.	TIMESTAMP
TINYINT	TINYINT
TINYTEXT	LONGVARCHAR
UNIQUEIDENTIFIER	CHAR
VARBINARY	VARBINARY
VARCHAR	VARCHAR

Limitations of Using Microsoft SQL Server Data Types

Note: When you use Microsoft SQL Server data types, note the following conditions:

When you insert a table with the TEXT, NTEXT, or IMAGE data type into a new project, the adapter fails to create a trigger, and the project cannot be saved.
When you insert a table with the MONEY, SMALLMONEY, DECIMAL, or NUMERICA data type into a project, if you request the numbers with high precision, you must choose string instead of r8 in the AE Type field in the Schema tab.
When you create a table that contains the TIMESTAMP data type, the publishing tables cannot be created.