aspose.cells

Class SqlDataType

Utility class containing constants. Specifies SQL data type of the parameter. Only valid for ODBC sources.

Field Summary
const  NumberSQL_UNSIGNED_OFFSET
sql unsigned offset
const  NumberSQL_SIGNED_OFFSET
sql signed offset
const  NumberSQL_GUID
sql guid
const  NumberSQL_W_LONG_VARCHAR
sql wide long variable char
const  NumberSQL_W_VARCHAR
sql wide variable char
const  NumberSQL_W_CHAR
sql wide char
const  NumberSQL_BIT
sql bit
const  NumberSQL_TINY_INT
sql tiny int
const  NumberSQL_BIG_INT
sql big int
const  NumberSQL_LONG_VAR_BINARY
sql long variable binary
const  NumberSQL_VAR_BINARY
sql variable binary
const  NumberSQL_BINARY
sql binary
const  NumberSQL_LONG_VAR_CHAR
sql long variable char
const  NumberSQL_UNKNOWN_TYPE
sql unknown type
const  NumberSQL_CHAR
sql char
const  NumberSQL_NUMERIC
sql numeric
const  NumberSQL_DECIMAL
sql decimal
const  NumberSQL_INTEGER
sql integer
const  NumberSQL_SMALL_INT
sql small int
const  NumberSQL_FLOAT
sql float
const  NumberSQL_REAL
sql real
const  NumberSQL_DOUBLE
sql double
const  NumberSQL_TYPE_DATE
sql date type
const  NumberSQL_TYPE_TIME
sql time type
const  NumberSQL_TYPE_TIMESTAMP
sql timestamp type
const  NumberSQL_VAR_CHAR
sql variable char
const  NumberSQL_INTERVAL_YEAR
sql interval year
const  NumberSQL_INTERVAL_MONTH
sql interval month
const  NumberSQL_INTERVAL_DAY
sql interval day
const  NumberSQL_INTERVAL_HOUR
sql interval hour
const  NumberSQL_INTERVAL_MINUTE
sql interval minute
const  NumberSQL_INTERVAL_SECOND
sql interval second
const  NumberSQL_INTERVAL_YEAR_TO_MONTH
sql interval year to month
const  NumberSQL_INTERVAL_DAY_TO_HOUR
sql interval day to hour
const  NumberSQL_INTERVAL_DAY_TO_MINUTE
sql interval day to minute
const  NumberSQL_INTERVAL_DAY_TO_SECOND
sql interval day to second
const  NumberSQL_INTERVAL_HOUR_TO_MINUTE
sql interval hour to minute
const  NumberSQL_INTERVAL_HOUR_TO_SECOND
sql interval hour to second
const  NumberSQL_INTERVAL_MINUTE_TO_SECOND
sql interval minute to second
 

    • Field Detail

      • SQL_UNSIGNED_OFFSET

        const Number SQL_UNSIGNED_OFFSET
        sql unsigned offset
      • SQL_SIGNED_OFFSET

        const Number SQL_SIGNED_OFFSET
        sql signed offset
      • SQL_GUID

        const Number SQL_GUID
        sql guid
      • SQL_W_LONG_VARCHAR

        const Number SQL_W_LONG_VARCHAR
        sql wide long variable char
      • SQL_W_VARCHAR

        const Number SQL_W_VARCHAR
        sql wide variable char
      • SQL_W_CHAR

        const Number SQL_W_CHAR
        sql wide char
      • SQL_BIT

        const Number SQL_BIT
        sql bit
      • SQL_TINY_INT

        const Number SQL_TINY_INT
        sql tiny int
      • SQL_BIG_INT

        const Number SQL_BIG_INT
        sql big int
      • SQL_LONG_VAR_BINARY

        const Number SQL_LONG_VAR_BINARY
        sql long variable binary
      • SQL_VAR_BINARY

        const Number SQL_VAR_BINARY
        sql variable binary
      • SQL_BINARY

        const Number SQL_BINARY
        sql binary
      • SQL_LONG_VAR_CHAR

        const Number SQL_LONG_VAR_CHAR
        sql long variable char
      • SQL_UNKNOWN_TYPE

        const Number SQL_UNKNOWN_TYPE
        sql unknown type
      • SQL_CHAR

        const Number SQL_CHAR
        sql char
      • SQL_NUMERIC

        const Number SQL_NUMERIC
        sql numeric
      • SQL_DECIMAL

        const Number SQL_DECIMAL
        sql decimal
      • SQL_INTEGER

        const Number SQL_INTEGER
        sql integer
      • SQL_SMALL_INT

        const Number SQL_SMALL_INT
        sql small int
      • SQL_FLOAT

        const Number SQL_FLOAT
        sql float
      • SQL_REAL

        const Number SQL_REAL
        sql real
      • SQL_DOUBLE

        const Number SQL_DOUBLE
        sql double
      • SQL_TYPE_DATE

        const Number SQL_TYPE_DATE
        sql date type
      • SQL_TYPE_TIME

        const Number SQL_TYPE_TIME
        sql time type
      • SQL_TYPE_TIMESTAMP

        const Number SQL_TYPE_TIMESTAMP
        sql timestamp type
      • SQL_VAR_CHAR

        const Number SQL_VAR_CHAR
        sql variable char
      • SQL_INTERVAL_YEAR

        const Number SQL_INTERVAL_YEAR
        sql interval year
      • SQL_INTERVAL_MONTH

        const Number SQL_INTERVAL_MONTH
        sql interval month
      • SQL_INTERVAL_DAY

        const Number SQL_INTERVAL_DAY
        sql interval day
      • SQL_INTERVAL_HOUR

        const Number SQL_INTERVAL_HOUR
        sql interval hour
      • SQL_INTERVAL_MINUTE

        const Number SQL_INTERVAL_MINUTE
        sql interval minute
      • SQL_INTERVAL_SECOND

        const Number SQL_INTERVAL_SECOND
        sql interval second
      • SQL_INTERVAL_YEAR_TO_MONTH

        const Number SQL_INTERVAL_YEAR_TO_MONTH
        sql interval year to month
      • SQL_INTERVAL_DAY_TO_HOUR

        const Number SQL_INTERVAL_DAY_TO_HOUR
        sql interval day to hour
      • SQL_INTERVAL_DAY_TO_MINUTE

        const Number SQL_INTERVAL_DAY_TO_MINUTE
        sql interval day to minute
      • SQL_INTERVAL_DAY_TO_SECOND

        const Number SQL_INTERVAL_DAY_TO_SECOND
        sql interval day to second
      • SQL_INTERVAL_HOUR_TO_MINUTE

        const Number SQL_INTERVAL_HOUR_TO_MINUTE
        sql interval hour to minute
      • SQL_INTERVAL_HOUR_TO_SECOND

        const Number SQL_INTERVAL_HOUR_TO_SECOND
        sql interval hour to second
      • SQL_INTERVAL_MINUTE_TO_SECOND

        const Number SQL_INTERVAL_MINUTE_TO_SECOND
        sql interval minute to second