Setting Precision and Scale

The cbPrecision value (for non-numeric datatypes) and the num.cbPrecision and num.ibScale values should reflect the actual precision and scale of the source data for the column. The ODBC interpretation of these values is described in the Microsoft ODBC 2.0 Programmer's Reference and SDK Guide. For fixed-length datatypes, the cbPrecision value should match the precision value (column 3) coded in the resources DLL and the precision value returned by sp_columns for that datatype. For variable-length datatypes, cbPrecision should always be less than or equal to the precision value in the resources DLL and equal to the precision value in sp_columns.