Member Avatar

Hi

iam using sql server 2008 to deal with my DB, i have a column with 'int' data type when i insert number inside that column like "0025648" it return it to me "25648" without zeros why ? and how to solve this problem ?

Best Regard
IT_Techno

  • 2 Contributors
  • forum 2 Replies
  • 171 Views
  • 22 Hours Discussion Span
  • comment Latest Post Latest Post by IT_Techno

Recommended Answers

Answered by pritaeas 2,045 in a post from

An integer column has no formatting so the zeroes are useless to it. Is there a reason you need it stored in the database like that? Adding zeroes is just a presentation issue.

Jump to Post

All 2 Replies

Member Avatar

An integer column has no formatting so the zeroes are useless to it. Is there a reason you need it stored in the database like that? Adding zeroes is just a presentation issue.

Member Avatar

I have changed my column datatype to "NVARCHAR", it's go on thnks for replay

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!