JudgementDay Posted February 4, 2012 Share Posted February 4, 2012 Can decimals be used with the INT data type? Quote Link to comment Share on other sites More sharing options...
JudgementDay Posted February 4, 2012 Author Share Posted February 4, 2012 So, could "21.50" be used in a row set to INT or would it need to be in a row set to VARCHAR? Quote Link to comment Share on other sites More sharing options...
Andy-H Posted February 4, 2012 Share Posted February 4, 2012 You can use decimal or double with length 10,2 (the value before the comma being the integer length and the value after being the float precision) i.e. 10,2 would allow up-to 9999999999.99 Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted February 4, 2012 Share Posted February 4, 2012 Integers are whole numbers. MySQL numeric data types Quote Link to comment Share on other sites More sharing options...
JudgementDay Posted February 6, 2012 Author Share Posted February 6, 2012 Thanks for the information. Quote Link to comment 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.