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 loaded as Signed(30,9). If this is not suitable, use a virtual field 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 field length and decimals, you may create a virtual field of (30,9) that is set to the value of this column. Alternatively, you may delete the field from the file.