Archives of the TeradataForum
Message Posted: Mon, 05 May 2003 @ 18:14:42 GMT
The long term solution (it may be very long term) is for Spreadsheet vendors to start using an 8 byte floating point value instead of the current IEEE 4 byte standard.
All spreadsheets that I have used (including Microsoft Excel and the spreadsheet used within SQL Assistant) store floating point values (this includes 'Decimal' columns) in IEEE format. This format allows for 15 to 16 digits of accuracy ... with no way to improve it.
The only possible solution in SQL Assistant is therefore to display the data in character format. While this works it is a 'sub-optimal' solution ... for the reasons expressed in this email thread. (This is why it is NOT the default, and must be specifically requested via the Option setting.)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|