• The DBMS Server can truncate leading zeros, or all or part of the fractional part of a number if necessary. If truncation of the non-fractional part of a value (other than leading zeros) is necessary, an overflow error results. These errors are reported only if numeric overflow error handling (see Specify Error Handling for Arithmetic) is set to warn or fail.

• If the receiving column or variable specifies more digits to the right of the decimal point than is present in the assignment value, the assignment value is padded with trailing zeros.

• When a float, float4, decimal, or money value is assigned to an integer column or variable, the fractional part is truncated.

• When a decimal value with a scale greater than two is assigned to a money column or variable, the fractional value is rounded.

• Character data is subject to numeric syntax checks if assigned in a numeric or money context.