Standard SQL data types

Standard HCL OneDB™ SQL data types have corresponding HCL OneDB ODBC Driver data types.

The following table lists the standard HCL OneDB SQL data types and their corresponding HCL OneDB ODBC Driver data types.
HCL OneDB SQL data type HCL OneDB ODBC driver SQL data type (fSqlType) Description
BIGINT SQL_INFX_BIGINT Signed numeric value with precision 10, scale 0, and range n

((263 - 1) n 263 1)
BIGSERIAL SQL_INFX_BIGINT Sequential positive integers to 263 1)
BOOLEAN SQL_BIT t' or f'
BYTE SQL_LONGVARBINARY Binary data of variable length
CHAR(n), CHARACTER(n) SQL_CHAR Character string of fixed length n

(1 n 32,767)
CHARACTER VARYING(m, r) SQL_VARCHAR Character string of variable length with maximum length m (1 m 255) and minimum amount of reserved space r (0 r < m)
DATE SQL_DATE Calendar date
DATETIME SQL_TIMESTAMP Calendar date and time of day
DEC(p,s), DECIMAL(p, s) SQL_DECIMAL Signed numeric value with precision p and scale s:

(1 p 32; 0 s p)

Important:
  • If you use a value for scale > 14, inconsistencies in rounding are possible.
  • When a DECIMAL column contains floating-point data, HCL OneDB ODBC reports the column's scale as 255. This is to differentiate from fixed-point data, which has a maximum scale of 32. The DataDirect ODBC Driver always returns a scale of zero.
DOUBLE PRECISION SQL_DOUBLE Signed numeric value with the same characteristics as the standard C double data type
FLOAT SQL_DOUBLE Signed numeric value with the same characteristics as the standard C double data type
IDSSECURITYLABEL Built-in DISTINCT OF VARCHAR(128) data type; use is restricted to label-based access control
INT, INTEGER SQL_INTEGER Signed numeric value with precision 10, scale 0, and range n

(-2,147,483,647 n 2,147,483,647)
INT8 SQL_BIGINT Signed numeric value with precision 10, scale 0, and range n

((263 - 1) n 263 1)
INTERVAL MONTH(p) SQL_INTERVAL_MONTH Number of months between two dates; p is the interval leading precision.
INTERVAL YEAR(p) SQL_INTERVAL_YEAR Number of years and months between two dates; p is the interval leading precision.
INTERVAL YEAR(p) TO MONTH SQL_INTERVAL_YEAR_TO_MONTH Number of years and months between two dates; p is the interval leading precision.
INTERVAL DAY(p) SQL_INTERVAL_DAY Number of days between two dates; p is the interval leading precision.
INTERVAL HOUR(p) SQL_INTERVAL_HOUR Number of hours between two date times; p is the interval leading precision.
INTERVAL MINUTE(p) SQL_INTERVAL_MINUTE Number of minutes between two date/times; p is the interval leading precision.
INTERVAL SECOND(p,q) SQL_INTERVAL_SECOND Number of seconds between two date/times; p is the interval leading precision and q is the interval seconds precision.
INTERVAL DAY(p) TO HOUR SQL_INTERVAL_DAY_TO_HOUR Number of days/hours between two date/times; p is the interval leading precision.
INTERVAL DAY(p) TO MINUTE SQL_INTERVAL_DAY_TO_MINUTE Number of days/hours/minutes between two date/times; p is the interval leading precision.
INTERVAL DAY(p) TO SECOND(q) SQL_INTERVAL_DAY_TO_SECOND Number of days/hours/minutes/seconds between two date/times; p is the interval leading precision and q is the interval seconds precision.
INTERVAL HOUR (p) TO MINUTE SQL_INTERVAL_HOUR_TO_MINUTE Number of hours/minutes between two date/times; p is the interval leading precision.
INTERVAL HOUR(p) TO SECOND(q) SQL_INTERVAL_HOUR_TO_SECOND Number of hours/minutes/seconds between two date/times; p is the interval leading precision and q is the interval seconds precision.
INTERVAL MINUTE(p) TO SECOND(q) SQL_INTERVAL_MINUTE_TO_SECOND Number of minutes/seconds between two date/times; p is the interval leading precision and q is the interval seconds precision.
LVARCHAR SQL_VARCHAR Character string of variable length with length l

(255 l 32,000)

When connecting to HCL OneDB 10.0 servers with the ODBC driver, the SQLDescribeCol, SQLColAttributes & SQLDescribeParam APIs report the length mentioned during creation of the LVARCHAR column. If no length was mentioned during creation, length defaults to 2048 bytes.
MONEY(p, s) SQL_DECIMAL Signed numeric value with precision p and scale s

(1 p 32; 0 s p)
NUMERIC SQL_NUMERIC Signed, exact, numeric value with precision p and scale s

(1 p 15; 0 s p)
REAL SQL_REAL Signed numeric value with the same characteristics as the standard C float data type
SERIAL SQL_INTEGER Sequential INTEGER
SERIAL8 SQL_BIGINT Sequential INT8
SMALLFLOAT SQL_REAL Signed numeric value with the same characteristics as the standard C float data type
SMALLINT SQL_SMALLINT Signed numeric value with precision 5, scale 0, and range n

(32,767 n 32,767)
TEXT SQL_LONGVARCHAR Character string of variable length
VARCHAR(m, r) SQL_VARCHAR Character string of variable length with maximum length m (1 m 255) and minimum amount of reserved space r (0 r < m)