Data types that are supported in CleverPath Reporter

Document ID : KB000055784
Last Modified Date : 14/02/2018
Show Technical Document Details

The different data types are listed below per databases.

Sybase:

Supported datatype:

SYBINT1(numeric)
SYBINT2(numeric)
SYBINT4(numeric)
SYBFLT8 (numeric)
SYBMONEY(numeric)
SYBMONEY4 (numeric)
SYBMONEYN (numeric)
SYBREAL (numeric)
SYBBIT (numeric)
SYBINTN (numeric)
SYBFLTN(numeric)
SYBDATETIME4 (date)
SYBDATETIME (date)
SYBBINARY (char)
SYBVARBINARY (char)

Not Supported datatype( An error message will be issued):

SYBIMAGE

Unrecognized datatypes are treated as char.

These unrecognized datatypes treated as char probably work correctly:

SYBCHAR  
SYBTEXT  
SYBDECIMAL   if format is c*
SYBNUMERIC   if format is c*
SYBLONGCHAR  
SYBVARCHAR

These unrecognized datatypes treated as char probably do not work correctly:

SYBBINARY  
SYBLONGBINARY  
SYBBOUNDARY  
SYBSENSITIVITY

Sybase/CT:

Supported datatype:

CS_TINYINT_TYPE (numeric)
CS_SMALLINT_TYPE (numeric)
CS_INT_TYPE (numeric)
CS_FLOAT_TYPE (numeric)
CS_REAL_TYPE (numeric)
CS_MONEY_TYPE (numeric)
CS_MONEY4_TYPE (numeric)
CS_BIT_TYPE (numeric)
CS_DECIMAL_TYPE (numeric)
CS_NUMERIC_TYPE (numeric)
CS_LONG_TYPE (numeric)
CS_DATETIME4_TYPE (date)
CS_DATETIME_TYPE (date)
CS_BINARY_TYPE  (char)
CS_LONGBINARY_TYPE (char)
CS_VARBINARY_TYPE (char)

Not Supported datatype( An error message will be issued):

CS_IMAGE_TYPE

Unrecognized datatypes are treated as char.

These unrecognized datatypes treated as char probably work correctly:

CS_CHAR_TYPE  
CS_LONGCHAR_TYPE  
CS_TEXT_TYPE  
CS_VARCHAR_TYPE

These unrecognized datatypes treated as char probably do not work correctly:

CS_SENSITIVITY_TYPE  
CS_BOUNDARY_TYPE

SQL Server:

Supported datatype:

SQLINT1 (numeric)
SQLINT2 (numeric)
SQLINT4 (numeric)
SQLINTN (numeric)
SQLFLT4 (numeric)
SQLFLT8 (numeric)
SQLFLTN (numeric)
SQLBIT (numeric)
SQLMONEY (numeric)
SQLMONEY4 (numeric)
SQLMONEYN (numeric)
SQLDATETIM4 (date)
SQLDATETIME (date)
SQLDATETIMN (date)
SQLBINARY   (char)
SQLVARBINARY (char)
SQLTEXT (char)

Not Supported datatype( An error message will be issued):

SQLIMAGE

Unrecognized datatypes are treated as char.

These unrecognized datatypes treated as char probably work correctly:

SQLCHAR  
SQLDECIMAL   if the format is c*
SQLNUMERIC   if the format is c*

Infomix:

Supported datatype:

SQLSMINT (numeric)
SQLINT (numeric)
SQLSERIAL (numeric)
SQLFLOAT (numeric)
SQLSMFLOAT (numeric)
SQLDECIMAL (numeric)
SQLMONEY (numeric)
SQLDATE (date)
SQLDTIME (date)
SQLINTERVAL (char)
SQLVCHAR (char)
SQLNVCHAR (char windows only)
SQLCHAR   (char windows only)
SQLNCHAR (char)

Not Supported datatypes( An error message will be issued):

SQLNULL
SQLBYTES
SQLTEXT

Any unrecognized datatypes will cause an error message to be issued.

Ingres:

Supported datatype:

IISQ_MNY_TYPE  (numeric) 
IISQ_DEC_TYPE  (numeric)
IISQ_INT_TYPE  (numeric)
IISQ_FLT_TYPE  (numeric)
IISQ_DTE_TYPE (date)
IISQ_LBYTE_TYPE (char) 
IISQ_LVCH_TYPE (char)

Unrecognized datatypes are treated as char.

These unrecognized datatypes treated as char probably work correctly:

IISQ_CHA_TYPE  
IISQ_VCH_TYPE  
IISQ_NCHR_TYPE  
IISQ_NVCHR_TYPE  
IISQ_LNVCHR_TYPE  
IISQ_TXT_TYPE  
IISQ_CHR_TYPE

These unrecognized datatypes treated as char probably do not work correctly:

IISQ_TBL_TYPE  
IISQ_OBJ_TYPE  
IISQ_BYTE_TYPE  
IISQ_VBYTE_TYPE

DB2:

Supported datatype:

SQL_SMALLINT (numeric)
SQL_INTEGER (numeric)
SQL_DECIMAL (numeric)
SQL_NUMERIC (numeric)
SQL_DOUBLE (numeric)
SQL_FLOAT (numeric)
SQL_REAL (numeric)
SQL_DATE (date)
SQL_TIME (date)
SQL_TIMESTAMP (date)
SQL_CHAR (char)
SQL_BIGINT (char)
SQL_CLOB (char)
SQL_BLOB (char)

Unrecognized datatypes are treated as char.

These unrecognized datatypes treated as char probably work correctly:

SQL_LONGVARCHAR

These unrecognized datatypes treated as char probably do not work correctly:

SQL_GRAPHIC  
SQL_VARGRAPHIC  
SQL_LONGVARGRAPHIC

ODBC:

Supported datatype:

SQL_BIT (numeric) 
SQL_TINYINT (numeric)
SQL_SMALLINT (numeric)
SQL_INTEGER  (numeric)
SQL_BIGINT  (numeric)
SQL_REAL (numeric)
SQL_FLOAT (numeric)
SQL_DOUBLE (numeric)
SQL_DECIMAL (numeric)
SQL_NUMERIC (numeric)
SQL_TIMESTAMP (date)
SQL_DATE (date)
SQL_TIME (date)

Unrecognized datatypes are treated as char.

These unrecognized datatypes treated as char probably work correctly:

SQL_CHAR  
SQL_VARCHAR  
SQL_LONGVARCHAR

These unrecognized datatypes treated as char probably do not work correctly:

SQL_BINARY  
SQL_VARBINARY  
SQL_LONGVARBINARY

Oracle:

Supported datatype:

NUMBER (numeric)
DATE  (date)
CHAR (char)
VARCHAR2(char)
LONG(char)

Unrecognized datatypes are treated as char.