SQL to C: Numeric

The identifiers for the numeric ODBC SQL data types are:

SQL_DECIMAL SQL_BIGINT
SQL_NUMERIC SQL_REAL
SQL_TINYINT SQL_FLOAT
SQL_SMALLINT SQL_DOUBLE
SQL_INTEGER

The following table shows the ODBC C data types to which numeric SQL data may be converted. For an explanation of the columns and terms in the table, see “Converting Data from SQL to C Data Types.”

C type identifier

Test

*TargetValuePtr

*StrLen_or _IndPtr

SQL- STATE

SQL_C_CHAR

Character byte length < BufferLength Number of whole (as opposed to fractional) digits < BufferLength Number of whole (as opposed to fractional) digits >= BufferLength

Data Truncated data Undefined

Length of data in bytes Length of data in bytes Undefined

n/a 01004 22003

SQL_C_STINYINT SQL_C_UTINYINT SQL_C_TINYINT SQL_C_SBIGINT SQL_C_UBIGINT SQL_C_SSHORT SQL_C_USHORT SQL_C_SHORT SQL_C_SLONG SQL_C_ULONG SQL_C_LONG SQL_C_NUMERIC

Data converted without truncation [a] Data converted with truncation of fractional digits [a] Conversion of data would result in loss of whole (as opposed to fractional) digits [a]

Data Truncated data Undefined

Size of the C data type Size of the C data type Undefined

n/a 01S07 22003

SQL_C_FLOAT SQL_C_DOUBLE

Data is within the range of the data type to which the number is being converted [a] Data is outside the range of the data type to which the number is being converted [a]

Data Undefined

Size of the C data type Undefined

n/a 22003

SQL_C_BIT

Data is 0 or 1 [a] Data is greater than 0, less than 2, and not equal to 1 [a] Data is less than 0 or greater than or equal to 2 [a]

Data Truncated data Undefined

1 [b] 1 [b] Undefined

n/a 01S07 22003

SQL_C_BINARY

Byte length of data <= BufferLength Byte length of data > BufferLength

Data Undefined

Length of data Undefined

n/a 22003

SQL_C_INTERVAL_ MONTH [c] SQL_C_INTERVAL_ YEAR [c] SQL_C_INTERVAL_ DAY [c] SQL_C_INTERVAL_ HOUR [c] SQL_C_INTERVAL_ MINUTE [c] SQL_C_INTERVAL_ SECOND [c]

Data not truncated Fractional seconds portion truncated Whole part of number truncated

Data Truncated data Undefined

Length of data in bytes Length of data in bytes Undefined

n/a 01S07 22015

SQL_C_INTERVAL_ YEAR_TO_MONTH SQL_C_INTERVAL_ DAY_TO_HOUR SQL_C_INTERVAL_ DAY_TO_MINUTE SQL_C_INTERVAL_ DAY_TO_SECOND SQL_C_INTERVAL_ HOUR_TO_MINUTE SQL_C_INTERVAL_ HOUR_TO_SECOND

Whole part of number truncated

Undefined

Undefined

22015

[a] The value of BufferLength is ignored for this conversion. The driver assumes that the size of *TargetValuePtr is the size of the C data type. [b] This is the size of the corresponding C data type. [c] This conversion is supported only for the exact numeric data types (SQL_DECIMAL, SQL_NUMERIC, SQL_TINYINT, SQL_SMALLINT, SQL_INTEGER, and SQL_BIGINT). It is not supported for the approximate numeric data types (SQL_REAL, SQL_FLOAT, or SQL_DOUBLE).