The scale of a numeric column or parameter refers to the maximum number of digits to the right of the decimal point. Note that, for approximate floating point number columns or parameters, the scale is undefined, since the number of digits to the right of the decimal place is not fixed.
The following table defines the scale for each SQL data type.
SQLTYPE |
Scale |
EDS_SQL_CHAR EDS_SQL_VARCHAR EDS_SQL_LONGVARCHAR |
Not applicable. |
EDS_SQL_DECIMAL EDS_SQL_NUMERIC |
The defined number of digits to the right of the decimal place. For example, the scale of a column defined as NUMERIC(10,3) is 3. |
EDS_SQL_BIT EDS_SQL_TINYINT EDS_SQL_SMALLINT EDS_SQL_INTEGER EDS_SQL_BIGINT |
0 |
EDS_SQL_REAL EDS_SQL_FLOAT EDS_SQL_DOUBLE |
Not applicable. |
EDS_SQL_BINARY EDS_SQL_VARBINARY EDS_SQL_LONGVARBINARY |
Not applicable. |
EDS_SQL_DATE EDS_SQL_TIME |
Not applicable. |
EDS_SQL_TIMESTAMP |
The number of digits to the right of the decimal point in the “yyyy-mm-dd hh:mm:ss[.fff[fff]]” format. For example, if the TIMESTAMP data type uses the “yyyy-mm-dd hh:mm:ss.fff” format, the scale is 3. |
