Subject | Problem when Updating Column With Float DataType |
---|---|
Author | Chooi-Ting |
Post date | 2003-09-26T07:43:09Z |
hi,
When I tried to update a column with float datatype, the value that I
updated is not what I enter earlier.
for example:
update table1 set value = 44090914
where id = 1;
when I retrieve this record, the value is 44090912. is it hit the
maximum value of float data type ?
rgds
When I tried to update a column with float datatype, the value that I
updated is not what I enter earlier.
for example:
update table1 set value = 44090914
where id = 1;
when I retrieve this record, the value is 44090912. is it hit the
maximum value of float data type ?
rgds