float size?

2005-10-01 Thread Jerry Swanson
I have field in database type float. When I insert number like 12345.27 , number is inserted 12345.3 Why it happened?

Re: float size?

2005-10-01 Thread Paul DuBois
At 13:00 -0400 10/1/05, Jerry Swanson wrote: I have field in database type float. When I insert number like 12345.27 , number is inserted 12345.3 Why it happened? Rounding. What is the exact data type of the column? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB,