mediumint and decimal question

[mine0926]

I use MySQL 5.1 as backend and Netbeans for creating GUI application. In my table I have a field which has a data type of [b]mediumint[b]. When I insert a value at this field (example 25.55) when I view it in MySql it became 26.

What kind of data type should I give?

Thanks in advance,
geje

[Tolls]

mediumint is an integer.
You are giving it a decimal value, so the db rounds the value (up in this case) to fit it into the field.

If you want to store decimal values then use either DECIMAL or NUMERIC, and give the appropriate scales.

[mine0926]

Thanks. :)