Page History

&<img src="../resources/images/opentocr.png" title="Open Contents list" border="0"&>
You are here: Anchor_Toc43971109_Toc43971109 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.
&<img src="../resources/images/opentoc-dark.png" title="Open Contents List" border="0"&>