Yep, it's a signed number... Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807).
so that's your upper limit for the bigint field in mssql2000. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > The all-F's number in calculator is unsigned, and I bet BigInt is signed, > so > you loose one bit. That generally means you have to divide by two and > subtract one to get the largest positive integer that fits. > Mark > -----Original Message----- > From: Tony Weeg [mailto:tony@;navtrak.net] > Sent: Thursday, November 07, 2002 11:12 AM > To: CF-Talk > Subject: nrotbko: sql server big int > 18446744073709551615 > is what I come up with when I type FFFFFFFFFFFFFFFF > into my calculator, and transform hex to decimal. > FF = 1 Bit > FFFFFFFFFFFFFFFF = 8 Bits > BigInt as a datatype is an 8 Bit datatype right? > but I cant put this value.... > 18446744073709551615 > into a big int field? > any ideas on that ceiliing anyone? > thanks. > .tony > Tony Weeg > Senior Web Developer > Information System Design > Navtrak, Inc. > Fleet Management Solutions > www.navtrak.net > 410.548.2337 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
