Database Discussion - question w int range

Print Page | Close Window

question w int range

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16370
Printed Date: 29 March 2026 at 2:58pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: question w int range

Posted By: thebmwz4
Subject: question w int range
Date Posted: 28 August 2005 at 10:30pm

hi, i am now dtg an application and sql server 2000 is used.i am supposed to count the number of entries and i set up a 'postID' in the database with type Int.

I wanna ask that the length of the type Int in sql server 2k is only 4. so is tehre any way to solve the 'overflow ' issue when the number of entries is more than length of 4, ie >9999?

thanks!

Replies:

Posted By: michael
Date Posted: 28 August 2005 at 11:00pm

4 does not relate to the number of digits. Int can hold anything from -2,147,483,648 to +2,147,483,647

As I guess you started at 0 or 1 as most people do, you still have over 2 billion entries for your db before you get an overflow.

The 4 relates to bytes, as it is a 4 byte length integer

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: thebmwz4
Date Posted: 28 August 2005 at 11:08pm

hihi! thanks! ya realli boot me up. :)