jsp and mysql error

[Pravin Shirke]

how to insert a decimal value into mysql database.
eg: value like 2.5 to mysql field of datatype float.
but when i try to insert 2.5 from jsp to mysql database it get converted to 2 in the database??

[Paul Sturrock]

How is your float defined? How many digits do you allow after the decimal place?

[Campbell Ritchie]

I think you will have to provide more detail. What format have you got the 2.5 in, and what sort of variable to you put it into, before inserting it into the database?
How did you specify the float value?

[Scott Selikoff]

Show us the code. I imagine there's somewhere your converting it to integer.