ODBC Connector > Data type reference > ODBC data types and transformation data types
  

ODBC data types and transformation data types

The following table compares ODBC data types such as Microsoft Access or Excel that Data Integration supports and the corresponding transformation data types:
ODBC Data Type
Transformation Data Type
Description
Bigint
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 characters; precision 19, scale 0
Binary
Binary
1 to 104,857,600 bytes
Bit
String
1 to 104,857,600 characters
Char(L)
String
1 to 104,857,600 characters
Date
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Decimal(P, S)
Decimal
Precision 1 to 28, scale 0 to 28
Double
Double
Precision 15
Float
Double
Precision 15
Integer
Integer
-2,147,483,648 to 2,147,483,647 characters; precision 10, scale 0
Long Varbinary
Binary
1 to 104,857,600 bytes
Nchar
Nstring
1 to 104,857,600 characters
Ntext
Ntext
1 to 104,857,600 characters
Numeric
Decimal
Precision 1 to 28, scale 0 to 28
Nvarchar
Nstring
1 to 104,857,600 characters
Real
Real
Precision 7, scale 0
Smallint
Smallint
Precision 5, scale 0
Text
Text
1 to 104,857,600 characters
Time
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Timestamp
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Tinyint
Small Integer
Precision 5, scale 0
Varbinary
Binary
1 to 104,857,600 bytes
Varchar(L)
String
1 to 104,857,600 characters
Note: When the Secure Agent runs in Unicode data movement mode, the column precision that you specify for ODBC data types determines the number of characters the Secure Agent reads and writes.