Re: business users services
Posted by: Rick James
Date: September 05, 2014 01:22PM

> Do you specify a display width in your implementations?

I never explicitly specify a "display width". SHOW CREATE TABLE supplies the "(11)", which is sufficient to show the widest possible value (-2000000000 and similar values).

If I want a display width, then I will be writing in PHP (or some other language), and can do the displaying there. Or I sometimes use FORMAT().

> decimal(4,2)

limits the storage to 99.99. Not knowing your application, or the use of this field, I cannot advise other than to say that it should be big enough to allow for inflation, etc. It will be messy if you try to store 111.11 into DECIMAL(4,2) and don't check for errors/warnings -- the value will be silently turned into 99.99.

Options: ReplyQuote


Subject
Written By
Posted
August 02, 2014 01:02PM
August 03, 2014 04:01PM
August 31, 2014 05:56PM
Re: business users services
September 05, 2014 01:22PM
September 25, 2014 04:07PM
August 04, 2014 10:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.