ODBC function
|
Returns...
|
---|---|
SQLDescribeCol
|
Decimal digits of the columns it describes.
|
SQLDescribeParam
|
Decimal digits of the parameters it describes.
|
SQLProcedureColumns
|
Decimal digits in a column of a procedure.
|
SQLColumns
|
Decimal digits in specified tables (such as the base table, view, or a system table).
|
SQLColAttribute
|
Decimal digits of columns at the data source.
|
SQLGetTypeInfo
|
Minimum and maximum decimal digits of an SQL data type on a data source.
|
SQL type identifier
|
Decimal digits
|
---|---|
All character and binary types [1]
|
N/A
|
SQL_DECIMAL SQL_NUMERIC
|
The defined number of digits to the right of the decimal point. For example, the scale of a column defined as NUMERIC(10,3) is 3. (In some implementations, this can be a negative number to support storage of very large numbers without using exponential notation; for example, "12000" could be stored as "12" with a scale of -3. However, solidDB® does not support negative scale.)
|
All exact numeric types other than SQL_DECIMAL and SQL_NUMERIC [1]
|
0
|
All approximate data types [1]
|
N/A
|
SQL type identifier
|
Descriptor field corresponding to decimal digits
|
---|---|
All character and binary types
|
N/A
|
All exact numeric types
|
SCALE
|
All approximate numeric types
|
N/A
|
All datetime types
|
PRECISION
|