Supported SQL Datatypes

Composer's DB Data Block can access many common types of data stored in supported databases. The following tables summarize the level of support that Composer provides. The tables are organized by the Composer project type (Java or .NET), and by whether you're doing a standard SQL query or executing a stored procedure. The levels of support that Composer claims:

The levels of support that Composer claims:

?	Datatype is fully supported.
?*	Datatype is supported, but in the Composer UIs (Query Builder and Stored Procedure Helper), it may appear as "Unknown" or "Other." The queries themselves will work
?	Datatype is not currently supported.

Supported SQL Server Datatypes

Datatype	Java Project SQL query	Java Project Stored Procedure	.NET Project SQL query	.NET Project Stored Procedure
bigint	?	?	?	?
int	?	?	?	?
decimal	?	?	?	?
int	?	?	?	?
numeric	?	?	?	?
smallint	?	?	?	?
tinyint	?	?	?	?
float	?	?	?	?
real	?	?	?	?
date	?	?	?	?
datetime	?	?	?	?
datetimeoffset	?*	?*	?*	?*
char	?	?	?	?
text	?	?	?	?
varchar	?	?	?	?
nchar	?	?	?	?
ntext	?	?	?	?
nvarchar	?	?	?	?
binary	?	?	?	?
sql_variant	?	?	?*	?
timestamp	?	?	?	?

Supported Oracle Datatypes

Datatype	Java Project SQL query	Java Project Stored Procedure	.NET Project SQL query	.NET Project Stored Procedure
number	?	?	?	?
binary_float	?*	?*	?*	?*
binary_double	?*	?	?*	?*
date	?	?	?	?
char	?	?	?	?
varchar	?	?	?	?
varchar2	?*	?*	?*	?*
nchar	?*	?	?*	?
nvarchar2	?*	?	?*	?*