|
|
Archives of the TeradataForum
Message Posted: Thu, 13 Mar 2003 @ 21:00:45 GMT
Subj: | | Re: Retailers only---GTIN length changes |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, March 13, 2003 08:27 -->
| It would be nice to see Teradata implement an integer data type that was 8 bytes. This would provide plenty of room for fields of
this nature. | |
Actually, it wouldn't give you much more than you already have. The maximum value of a decimal(18,0) field is, of course,
999999999999999999; of a long long, 9223372036854775807. That's 19 digits, but you couldn't store a 19-digit number greater than that.
| |