Archives of the TeradataForum
Message Posted: Thu, 13 Mar 2003 @ 08:56:00 GMT
| Subj: || || Re: Retailers only---GTIN length changes |
| From: || || Dieter Nöth |
Yonina Schuchman wrote:
| ||We have a similar issue with debit card numbers. I'm not sure what the time frame is for those numbers to expand past 18 digits.
Decimal(18,0) served us well aside from the truncating 18th digit that occurred with various releases.|| |
This is mainly an ODBC issue, because there's no bigint in ODBC. It's converted to float, that's why the last 1 or two digits are
wrong. Run the same select using BTEQ and it's ok.