Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - question w int range
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

question w int range
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
thebmwz4 View Drop Down
Newbie
Newbie


Joined: 17 June 2005
Status: Offline
Points: 14 		Post Options Post Options   Thanks (0) Thanks(0)   Quote thebmwz4 Quote  Post ReplyReply Direct Link To This Post Topic: question w int range
    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!
 
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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
Blog | MPG Tracker
Back to Top
thebmwz4 View Drop Down
Newbie
Newbie


Joined: 17 June 2005
Status: Offline
Points: 14 		Post Options Post Options   Thanks (0) Thanks(0)   Quote thebmwz4 Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2005 at 11:08pm
hihi! thanks! ya realli boot me up. :)
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.