Problems When Converting Float Values In Double, Precision Not Maintained
(Doc ID 2118719.1)
Last updated on APRIL 25, 2018
Applies to:
MySQL Server - Version 5.5 and laterInformation in this document applies to any platform.
Goal
Describe what can be done after converting existing float-values into double-values with the following command:
ALTER Table example CHANGE COLUMN 'Value' 'Value' DOUBLE.
Double-values with numeric precision appears which had no numeric precision respectively had fewer numeric precision on float-values.
Example:
Float Value 1.01 was converted into Double 1.00999999046326.
to restore its original value while leaving the data type as Double? How to perform this?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |