 |
 |
Archives of the TeradataForum
Message Posted: Thu, 23 Sep 2004 @ 12:41:08 GMT
| Subj: | | Re: Impact of changing MaxDecimal from 15 to 18 |
| |
| From: | | Geoffrey Rommel |
| | 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. | |
| | 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... | |
Right you are, Dave. IBM DB2/UDB for Unix allows decimal columns of up to 31 digits, so I think that customers will soon expect other
vendors to follow suit.
| |
