http://qs1969.pair.com?node_id=449514


in reply to field lengths of database tables

Instead of SCALE, use PRECISION.

Check the DBI docs for some caveats about its applicability with numerical types.

To get reliable results, you should use $sth->{PRECISION} in coordination with the values of $sth->{TYPE}