tivisu Posted December 30, 2018 Share Posted December 30, 2018 Hi, in Mysql have a row with FLOAT 10,2 In form put the number 20.20 and after reload in form show: 20.200000762939 Quote Link to comment https://forums.phpfreaks.com/topic/308089-float-2-digit-show-lots-of-characters/ Share on other sites More sharing options...
requinix Posted December 30, 2018 Share Posted December 30, 2018 Use round when displaying it. 1 Quote Link to comment https://forums.phpfreaks.com/topic/308089-float-2-digit-show-lots-of-characters/#findComment-1563171 Share on other sites More sharing options...
tivisu Posted December 30, 2018 Author Share Posted December 30, 2018 Its work, thank You Quote Link to comment https://forums.phpfreaks.com/topic/308089-float-2-digit-show-lots-of-characters/#findComment-1563173 Share on other sites More sharing options...
Barand Posted December 30, 2018 Share Posted December 30, 2018 Alternatively, use a fixed precision type DECIMAL(10,2) instead of FLOAT Quote Link to comment https://forums.phpfreaks.com/topic/308089-float-2-digit-show-lots-of-characters/#findComment-1563174 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.