Method: Create Table AA (ID Char (10), V Decimal (18, 2)); INSERT INTO AA VALUES ('1', 99999999.9); Insert 8192 identical record select sum (v) from AA; result is 81919999918.08 that no error has been tested mysql 4.0.18 there is no error error firebird 1.5 The DECIMAL and NUMERIC types are implemented as the same type by MySQL. They are used to store values for which it is important to preserve exact precision, for example with monetary data WHEN DECLANG A Column of One of these Types
