jim.davidson Posted June 20, 2007 Share Posted June 20, 2007 I'm a newbie and I'm not sure which data type to use for fields that contain percentages and money. Example state tax field might be .02 or .045 price field anywhere from .01 to 1,000,000.00 Do I use smallint int signed, unsigned, and how do I define to decimal places Thanks for any help Quote Link to comment Share on other sites More sharing options...
Illusion Posted June 20, 2007 Share Posted June 20, 2007 DECIMAL UNSIGNED and DOUBLE UNSIGNED are of interest. Quote Link to comment Share on other sites More sharing options...
jim.davidson Posted June 20, 2007 Author Share Posted June 20, 2007 thank you Quote Link to comment Share on other sites More sharing options...
jim.davidson Posted June 20, 2007 Author Share Posted June 20, 2007 If I use decimal unsigned, what I read tells me that it's stored as a string. Does that mean that I would have to convert it to do any calculations with it (add, subtract, multiply, or divide)? Quote Link to comment Share on other sites More sharing options...
bubblegum.anarchy Posted June 21, 2007 Share Posted June 21, 2007 no Quote Link to comment Share on other sites More sharing options...
jim.davidson Posted June 21, 2007 Author Share Posted June 21, 2007 Thanks Bubblegum 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.