Re: data value changing for float column

walt wrote: > I've run into a weird problem. If I try to insert this value, 78978978, > into a FLOAT(9,2) column, the value changes. See below. > System info: > MySQL-shared-3.23.51-1 > MySQL-client-3.23.51-1 > MySQL-devel-3.23.51-1 > MySQL-Max-3.23.51-1 > MySQL-3.23.51-1 > Red Hat Linux release 7

data value changing for float column

I've run into a weird problem. If I try to insert this value, 78978978, into a FLOAT(9,2) column, the value changes. See below. System info: MySQL-shared-3.23.51-1 MySQL-client-3.23.51-1 MySQL-devel-3.23.51-1 MySQL-Max-3.23.51-1 MySQL-3.23.51-1 Red Hat Linux release 7.3 (Valhalla) #Wrong mysq