QPR Knowledge Base 2017.1

Supported Data Types in SQL Import

Supported Data Types in SQL Import

 Previous topic Next topic No directory for this topic  

Supported Data Types in SQL Import

 Previous topic Next topic Topic directory requires JavaScript Mail us feedback on this 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.