Ispirer Website Ispirer Capabilities: MySQL Migration Free Trial

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