RE: Having trouble storing monetary values...

2007-10-01 Thread Rick Faircloth
:[EMAIL PROTECTED] Sent: Monday, October 01, 2007 9:47 AM To: Rick Faircloth Cc: MySQL List Subject: Re: Having trouble storing monetary values... Hi Rick, (I'm CCing the list in again -- keeping the discussion on-list lets everyone see it and potentially solve their own problems by searchi

Re: Having trouble storing monetary values...

2007-10-01 Thread Baron Schwartz
mber 30, 2007 11:03 AM To: Rick Faircloth Cc: mysql@lists.mysql.com Subject: Re: Having trouble storing monetary values... Rick Faircloth wrote: Hi, all. I'm having trouble storing monetary values. When MySQL 5.0 stores the entered value of 5.23, it storing it as 5, dropping off the

Re: Having trouble storing monetary values...

2007-09-30 Thread Baron Schwartz
Rick Faircloth wrote: Hi, all. I'm having trouble storing monetary values. When MySQL 5.0 stores the entered value of 5.23, it storing it as 5, dropping off the values after the decimal. The field is the decimal type with 2 specified as the number of values to store after the dec