in reply to Re: Re: Managing Inventory Sections with Perl and SQL
in thread Managing Inventory Sections with Perl and SQL

decimal(9,2) means store up to 9 digits, with 2 digits precision, so you can store up to 9 999 999.99.

Michael

  • Comment on Re: Re: Re: Managing Inventory Sections with Perl and SQL

Replies are listed 'Best First'.
Re: Re: Re: Re: Managing Inventory Sections with Perl and SQL
by Anonymous Monk on Jul 29, 2003 at 09:15 UTC

    I double checked that and it appears correct. I somehow got the idea from the docs that the decimal place took up a spot (maybe I confused it with the sign). But you're right, thanks :)