Archives of the TeradataForum
Message Posted: Tue, 21 Sep 2004 @ 20:07:20 GMT
Subj: | | Re: Impact of changing MaxDecimal from 15 to 18 |
|
From: | | Dempsey, Mike |
Unfortunately the ODBC driver is not the problem. (SQLA retrieves the data in character format so it can handle 18 digits.) The spreadsheet
however (which is Excel compatible) can only display 15.
I am not aware of any spreadsheet products (which all follow the IEEE standard) that can handle more than 15 digits ... without switching to
character mode - as SQLA already allows.
Mike Dempsey
Teradata Client Tools
|