Hi all. I am trying to figure out if there is a way to configure MySQL so that when inserts occur on decimal fields where the value being inserted has more precision than the field specification, then the value inserted is rounded instead of truncated.
For example, if i have a column: Acres DECIMAL(14,3) NOT NULL DEFAULT 0 and i'm inserting the value '1.5467' currently, the value 1.546 is inserted. But i want the behaviour to round this number to 1.547 Is this possible, or will i have to do that manually (programmatically) for all the decimal fields that i want to behave this way. Note: The application htat i need this for is driven by Perl with the DBI / DBD::MySQL Thanks much -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] "The software required Windows 2000 or better, so i Downloaded Linux" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]