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

Nice solution! I like the flexibility. Thanks a lot :)

One more question: I'm using MySQL and wondering what format to store the price in, I was thinking an unsigned decimal(9, 2) would this be appropriate (If I remember properly it should allow values up to 999 999.99, correct?).

Thanks again! :)

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

Replies are listed 'Best First'.
Re: Re: Re: Managing Inventory Sections with Perl and SQL
by mpeppler (Vicar) on Jul 29, 2003 at 08:30 UTC
    decimal(9,2) means store up to 9 digits, with 2 digits precision, so you can store up to 9 999 999.99.

    Michael

[reply]

      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 :)

[reply]

In Section Seekers of Perl Wisdom