 |
 |
Archives of the TeradataForum
Message Posted: Wed, 22 Sep 2004 @ 19:08:36 GMT
| Subj: | | Re: Impact of changing MaxDecimal from 15 to 18 |
| |
| From: | | Hough, David A |
Modifying ODBC is not an option. The Microsoft ODBC Programmer's Reference, Appendix D (Data Types) defines data type SQL_DECIMAL as
DECIMAL(p,s) with 1<=p<=15 and 0<=s<=p. I'll go out on a limb and say that the definition matches the official standard.
DECIMAL(15) probably seemed plenty large when the standard was written; brings to mind the famous comment about 640K being all the memory
you'll ever need...
/dave hough
| |
