Post reply

DECIMAL Data Type Question

  • October 22, 2004 at 8:56 am

    #102246

    For decimal data type with precision 10-19 the storage is 9 bytes.

    Is there any difference storagewise if I declare my column as decimal (17, 3) vs decimal (19, 3)?

    Thanks

  • October 22, 2004 at 9:50 am

    #527679

    They will both use 9 bytes as you stated but

    (17,3) will only allow a maximum of 14 digits to the left of the decimal point

    (19,3) will allow 16

    Far away is close at hand in the images of elsewhere.
    Anon.

  • October 22, 2004 at 12:53 pm

    #527706

    Ok, thanks...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply