DataTypes

Data
Group		 Access Name SQL Name SSIS Name SAP HANA Description Min Max Accuracy Storage
integer Yes/No bit dt_bool boolean 0 to 1 0 1 1 1/8 byte
byte tinyint dt_ui1 tinyint 0 to 255 0 255 1 1 byte
int small int dt_i2 smallint -2^15 to 2^15-1
(32 thousand)		 -32,768 32,767 1 2 bytes
long int dt_i4 integer -2^31 to 2^31-1
(2 billion)		 -2,147,483,648 2,147,483,647 1 4 bytes
big int dt_i8 bigint -2^63 to 2^63-1
(9 thousand quadrillion)		 -9,223,372,036,854,775,808 9,223,372,036,854,775,807 1 8 bytes
Dec decimal decimal dt_decimal, [scale] decimal, [precision], [scale] 1 to 38 digits
(huge)		 -38 digits 38 digits total 38 decimal places n is 1-9 = 5 bytes
n is 10-19 = 9 bytes
n is 20-28 = 13 bytes
n is 29-38 = 17 bytes
numeric dt_numeric, [precision], [scale] see decimal
small money dt_cy decimal (10,4) (200 Thousand) -214,748.3648 214,748.3647 0.0001 4 bytes
currency money decimal (19,4) (900 trillion) -922,337,203,685,477.5808 922,337,203,685,477.5807 0.0001 8 bytes
double float dt_r8 float verify details match to SQL Approximate (huge number) -1.79E+308 1.79E+308 n is 1-24 = 7 digits
n is 25-53 = 15 digits		 n is 1-7 = 4 bytes
n is 8-15 = 8 bytes
single real dt_r4 real verify details match to SQL Approximate (huge number) -3.40E+38 3.40E+38 7 digits 4 bytes
Date date dt_dbdate date Days only Jan 1 , 0001 Dec 31 , 9999 1 day 3 bytes
date/time datetime dt_dbtimestamp 1753 through 9999, by day and time Jan 1 , 1753 - 00:00:00 Dec 31 , 9999 - 23:59:59.997 Rounded to increments of
.000 seconds
.003 seconds
.007 seconds		 8 bytes
seconddate 0001 through 9999, by day and time Jan 1 , 0001 - 00:00:00 Dec 31 , 9999 - 23:59:59 1 second
datetime2 dt_dbtimestamp2, [scale] 1753 through 9999, by day and time Jan 1 , 1753 - 00:00:00 Dec 31 , 9999 - 23:59:59.9999999 100 nanoseconds n is 1-2 = 6 bytes
n is 3-4 = 7 bytes
n is >=5 = 8 bytes
timestamp 0001 through 9999, by day and time Jan 1 , 0001 - 00:00:00.0000000 Dec 31 , 9999 - 23:59:59.9999999 100 nanoseconds
smalldatetime dt_dbtimestamp 1900 through 2079, by day and time

23:59:59 will round to the next day 00:00:00		 Jan 1 , 1900 - 00:00 Jun 6 , 2079 - 23:59 One minute 4 bytes
time dt_dbtime time Time only 00:00:00.0000000 23:59:59.9999999 100 nanoseconds 5 bytes
Text char dt_str char verify details match to SQL 1 to 8,000 characters 1 character 8,000 characters 1 character n
nchar dt_wstr nchar verify details match to SQL 1 to 8,000 characters 1 character 8,000 characters 1 character n * 2
text varchar dt_str varchar verify details match to SQL 1 to 8,000 characters 1 character 8,000 characters 1 character n
nvarchar dt_wstr nvarchar verify details match to SQL 1 to 8,000 characters 1 character 8,000 characters 1 character n * 2
memo text dt_text clob verify details match to SQL 1 to 2,147,483,647 characters (old versions of Access are limited to 65,536 characters 1 character 2,147,483,647 characters 1 character n
image dt_image blob verify details match to SQL 1 to 2,147,483,647 bytes 1 byte 2,147,483,647 bytes 1 byte n