RE: a struggle with float type display and width

I searched some more and then I found Bug # 10897 - FLOAT and DOUBLE obeying precision and scale. No documentation. http://bugs.mysql.com/bug.php?id=10897 Regards, Martin. > > Hi, > > I've recently changed MySQL versions and I am puzzled by the difference in > display of float values. >

a struggle with float type display and width

Hi, I've recently changed MySQL versions and I am puzzled by the difference in display of float values. CREATE TABLE test ( id int unsigned NOT NULL auto_increment, val1 float default NULL, val2 float(3,3) default NULL, val3 float(5,3) default NULL, val4 float(10,6) default NULL, PRIM