megz90 Posted March 31, 2008 Share Posted March 31, 2008 im very confused. i have a mysql table the firld type decimal(5,2) Unsigned not null ..... does this mean i can have 5 digits and 2 after the decimal point or max 5 digits (3 before and 2 after point) ive read 3 different websites and now im confused cus they have all said different things. i think my confusion is because of the changes in different mysql versions... im using version: 5.0.45 thanks anyone who knows. Link to comment https://forums.phpfreaks.com/topic/98891-decimal-52-very-basic-question/ Share on other sites More sharing options...
AndyB Posted March 31, 2008 Share Posted March 31, 2008 Trust the documentation: http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html 5,2 = five digits of which two are after the decimal Link to comment https://forums.phpfreaks.com/topic/98891-decimal-52-very-basic-question/#findComment-506022 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.