Post reply

preserve number

  • October 25, 2012 at 6:41 pm

    #284048

    hi,

    i am uploading filed from my file

    which has data like , 00001

    when i insert into my table in sql , it just save as 1 instead of 00001

    how to store the whole number

  • November 9, 2012 at 9:12 pm

    #1557876

    You'll need to store it as a character type (e.g. VARCHAR OR CHAR) to maintain leading zeroes.

    But why do you need leading zeroes? If it is a number then what importance do leading zeroes have? 0001 = 001 = 01 = 1 right?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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