Read back Double value with no loss of digits after the decimal place
Posted by: Andrew Whitworth
Date: July 26, 2019 03:04AM

Hi there,

I have an issue reading back a Double value from a MySQL database via the C# connector (v8.0.16).

When using MySQL Workbench (8.0.16) the value is read back correctly with no loss of digits after the decimal place - 0.00000009690000000000001

When read back using the C# connector, I cannot get the exact same value via MySqlDataReader:

reader.GetDouble - 9.6900000000000014E-08
reader.GetDecimal - 0.0000000969

How can I get the exact same value as displayed by MySql Workbench?

Regards,
Andrew

Options: ReplyQuote


Subject
Written By
Posted
Read back Double value with no loss of digits after the decimal place
July 26, 2019 03:04AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.