a problem about datatype

[nibabug]

hello everyone :) i define a datatype float, but when i write a value, for exsample '1.123',to the table, then i find that the value in the table changed to '1.123999999999999', what's the problem? thanks a lot :-D

wuhuaiji

[N a v a n e e t h]

By default float size will be 8. Try reducing it

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

[nibabug]

thanks , but it can not be reduced

wuhuaiji

[Marek Grzenkowicz]

Read about floating-point[^] and then use decimal and numeric data type.

[N a v a n e e t h]

nibabug wrote:

but it can not be reduced

I guess you tried through enterprise manager right ? Try through query analyzer, you can change it.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions