Please enable JavaScript to view this site.

QPR Knowledge Base 2019.1

Navigation: Developer's Guide > QPR Metrics Integration Kit

Supported Data Types in SQL Import

 Scroll Prev Top Next More

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.