It looks like the maximum precision for a DECIMAL column is 17 in MySQL.
Is this documented anywhere?  I get the following results:

mysql> CREATE TABLE `scale_test6` (`a_dec` decimal(30,23) default NULL)
TYPE=MyISAM;

mysql> INSERT INTO scale_test6 (a_dec) VALUES
(12345678.123456789012345678901234);

mysql> SELECT * FROM scale_test6;
+----------------------------------+
| a_dec                            |
+----------------------------------+
| 12345678.12345678900000000000000 |
+----------------------------------+
1 row in set (0.00 sec)

Am I doing everything correctly?  I would have expected to see the
entire decimal stored correctly in the table.

-- Matt Solnit <[EMAIL PROTECTED]>

Reply via email to