Ispirer Website
Ispirer Capabilities: MySQL Migration
Free Trial
Conversion of NUMBER Data Type Column with Comma
An Oracle table contains a column with a NUMBER data type (for example, precision = 21, scale = 5, decimal = comma):
When converting to MySQL, the fractional part may have been truncated:
To avoid this problem, it is necessary that the data of the decimal data type is written to a text file with a dot. To implement this behavior, you should set the “Decimal point” option on the Conversion Options page to a “.”, as shown in the screenshot below:
If you have any other questions, please contact us at support@ispirer.com