Archives of the TeradataForum

Message Posted: Mon, 05 May 2003 @ 18:14:42 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.)

Mike Dempsey
Developer - Teradata SQL Assistant

	<Prev	Next>		<<First	<Prev	Next>	Last>>