Jump to: navigation, search

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 ?* ? ?* ?*
This page was last edited on November 30, 2018, at 18:46.
Comments or questions about this documentation? Contact us for support!