QPR Knowledge Base 2012.1

Supported Data Types in SQL Import

Supported Data Types in SQL Import

Previous topic Next topic  

Supported Data Types in SQL Import

Previous topic Next topic  

Following SQL-data types are supported in SQL Import:

 

SQL_TINYINT

 

SQL_SMALLINT

 

SQL_INTEGER

 

SQL_DOUBLE

 

SQL_FLOAT

 

SQL_TYPE_TIMESTAMP

 

SQL_TYPE_DATE

 

SQL_TYPE_TIME

 

SQL_VARCHAR

 

SQL_LONGVARCHAR

 

SQL_DECIMAL

 

With these types, it should be possible to import any kind of numeric data from most of the databases. If some type does not fit, use cast function in SQL-query.

 

note

Note

SQL Queries may contain only Western characters (measure and series symbols can be using a Western character set only), date and value. Multi-byte characters are not supported in SQL import.