Having trouble storing monetary values...

[Rick Faircloth]

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 decimal.

 

Can anyone provide some clues on how to set up the field

or any other changes I need to make to properly store

the monetary values?

 

Thanks,

 

Rick