Number type

[Alan T]

Is the Integer type 4 byte long?
I have defined a SQL Server 2000 table has a field of Integer type with
length in 4, I want to define the same table in MS Access.

 

[storrboy]

Is the Integer type 4 byte long?
I have defined a SQL Server 2000 table has a field of Integer type with
length in 4, I want to define the same table in MS Access.

From the help files

"Integer variables are stored as 16-bit (2-byte) numbers ranging in
value from -32,768 to 32,767. The type-declaration character for
Integer is the percent sign (%)."

Longs and Singles are 4 bytes, Doubles are 8

 

[Allen Browne]

Access uses Integer to refer to a 2-byte number, and Long Integer to refer
to a 4-byte.

You might find this a useful reference:
Field type reference - names and values for DDL, DAO, and ADOX
at:
http://allenbrowne.com/ser-49.html

 

[Jamie Collins]

Access uses Integer to refer to a 2-byte number, and Long Integer to refer
to a 4-byte.

Not universally, though. In Access/Jet SQL DDL, the keyword INTEGER
refers to a four byte ('long') integer, so the following will create
the same data type in both SQL Server and Access/Jet:

CREATE TABLE DropMe (col1 INTEGER);

Jamie.

--