Handling of large numeric columns

Columns with a precision higher than 30 will be created as a field with a length of 30. Columns with a scale higher than 9 will be created with decimals of 9.

Floating point columns are imported as Signed(30,9). If this is not suitable, use a virtual column that is more appropriate.

Values with more than 30 significant digits or 9 decimal places are not handled. Data may be truncated at either end.

If you know that the values are unlikely to exceed the column length and decimals, you may create a virtual column of (30,9) that is set to the value of this column. Alternatively, you may delete the column from the table.