Please enable JavaScript to view this site.

QPR Knowledge Base 2023.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.