Talk:Long integer

From Wikipedia, the free encyclopedia

These details about MySQL Server data types have been removed from this article as they are not relevant. The information about data sizes in general is already available on other pages (e.g. Integer (computer science)) --HappyDog 23:29, 28 Oct 2004 (UTC)

Microsoft SQL Server 2000 has the following sizes of integer data types:

bigint

Has a length of 8 bytes and stores numbers from

–2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807).

integer or int

Has a length of 4 bytes, and stores numbers from -2,147,483,648 through 2,147,483,647.

smallint

Has a length of 2 bytes, and stores numbers from -32,768 through 32,767.

tinyint

Has a length of 1 byte, and stores numbers from 0 through 255.

---

Does this page merit a computing-related stub notice? To me, computer science is related to computers, but I'm not a programmer or anyone else who deals with the subject. However, the main article quotes Edsger Dijkstra that it's "no more about computers than astronomy is about telescopes." --Theaterfreak64 23:57, Feb 7, 2005 (UTC)

The purpose of using a specific stub notice is to help people knowledgeable in a field find stubs that they may be able to work on, so yes I think it would be very appropriate here. If there were separate stub notices about 'computer science' and 'computers' then I think dijkstra's famous quote would apply, but in this context the distinction is not relevant. --HappyDog 00:36, 8 Feb 2005 (UTC)

[edit] What

Is a long not 8 bytes? This page gives the impression that it's 4, but a standard integer is 4 bytes. - Ferret 21:47, 29 June 2006 (UTC)

I think this page might be fucked, unless the standard definition of long is different from Java's. This page here: (http://java.sun.com/j2se/1.4.2/docs/api/java/lang/Long.html) says a long ranges from -2⁶³ to 2⁶³-1. The wiki says it goes from -2³¹ to 2³¹-1. This range is more consistent with a regular old int: http://java.sun.com/j2se/1.4.2/docs/api/java/lang/Integer.html

What gives? Sean Gray 08:51, 2 November 2006 (UTC)

Who said a long needs to be the same for all architecutres and/or languages. j.engelh 22:31, 1 December 2006 (UTC)

Indeed. Please read the first sentence: "In computer science, a long integer is a variable that can hold a positive or negative whole number whose range is greater or equal to that of a standard integer on the same machine." --HappyDog 17:48, 2 December 2006 (UTC)

Reality said so. Long integer is a starndard, and standards are what allow computers and the internet as we know them to function. Furthermore, in the .NET Framework, COM/COM+, SQL Server, Oracle, MySql, MS Access, and indeed the Windows Kernal itself, a long integer is eight bytes, while a standard integer is four. DigitalEnthusiast 21:02, 18 December 2006 (UTC)

Int32 redirects here. 32 bits / 8 bits-per-byte = four bytes, not eight. DigitalEnthusiast 21:05, 18 December 2006 (UTC)

DigitalEnthusiast, it's time to live up to your name and research computer numbering formats... :-) --HappyDog 02:03, 19 December 2006 (UTC)

You're right about VBA and older versions of VB ( standalone ), but the fact remains that Int32 shouldn't redirect to this page. It's a specific .net data type, and 8-bytes of storage. Int64 is the .net version of what's described here.

You might be right. Then again, these terms may be used in other contexts where they have different definitions. Either way, there is room for confusion. I think they should probably both redirect to integer, or perhaps a list of data types (if there is a standalone list) but I can't say that with any certainty. Does anyone else have any thoughts on this? --HappyDog 21:59, 20 December 2006 (UTC)