whoa guys slow down a bit. an int is probably a 32 bit signed int so 2^31 = 2147483648 (hex 80000000) if its 64 bit (more than likely signed) (2^63) = 9223372036854775808 (hex 8000000000000000)
-----Original Message----- From: Nelson Winters [mailto:nwinters@;mindspring.com] Sent: Thursday, November 07, 2002 8:53 AM To: CF-Talk Subject: Re: nrotbko: sql server big int I think FF = 1 Byte = 8 Bits AND FFFFFFFFFFFFFFFF = 8 Bytes = 64 Bits 18446744073709551615 = 2^64 However to account for negative numbers, 1 bit is used to determine if the number is positive or negative. So, if I'm correct, the upper limit would be 2^64 or ~ 9.22337 * 10^18 (I can't calculate the number exactly). If you determine the exact value of 2^63, you should be able to store this number, but 2^63 + 1 should not be able to be stored. Nelson ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 11:11 AM 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
