Designer Guide

10.5.7
- 10.5.6
- 10.5
- 10.4.1
- 10.4.0

Back Next

Microsoft SQL Server and Transformation Datatypes

The following table compares Microsoft SQL Server datatypes and transformation datatypes:

Microsoft SQL	Range	Transformation	Range
Bigint	-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807	Bigint	-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0
Binary(L)	1 to 8,000 bytes	Binary	1 to 104,857,600 bytes
Bit	1 bit	String	1 to 104,857,600 characters
Char(L)	1 to 8,000 characters	String	1 to 104,857,600 characters
Datetime	Jan 1, 1753 A.D. to Dec 31, 9999 A.D. Precision 23, scale 3 (precision to 3.33 milliseconds)	Date/Time	Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Datetime2	Jan 1,1 A.D. to Dec 31, 9999 A.D. Precision 27, scale 7 (precision to 100 nanoseconds)	Date/Time	Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Decimal(P,S)	Precision 1 to 38, scale 0 to 38	Decimal	Precision 1 to 28, scale 0 to 28
Float	-1.79E+308 to 1.79E+308	Double	Precision 15
Image	1 to 2,147,483,647 bytes	Binary	1 to 104,857,600 bytes
Int	-2,147,483,648 to 2,147,483,647	Integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
Money	-922,337,203,685,477.5807 to 922,337,203,685,477.5807	Decimal	Precision 1 to 28, scale 0 to 28
Nchar	1 to 4,000 characters	Nstring	1 to 104,857,600 characters
Ntext	1 to 1,073,741,823 characters	Ntext	1 to 104,857,600 characters
Numeric(P,S)	Precision 1 to 38, scale 0 to 38	Decimal	Precision 1 to 28, scale 0 to 28
Numeric Identity	1 to 9,999	Integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
Nvarchar	1 to 4,000 characters	Nstring	1 to 104,857,600 characters
Real	-3.40E+38 to 3.40E+38	Real	Precision 7, scale 0
Smalldatetime	Jan 1, 1900, to June 6, 2079 Precision 19, scale 0 (precision to the minute)	Date/Time	Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Smallint	-32,768 to 32,768	Small Integer	Precision 5, scale 0
Smallmoney	-214,748.3648 to 214,748.3647	Decimal	Precision 1 to 28, scale 0 to 28
Sysname	1 to 128 characters	Nstring	1 to 104,857,600 characters
Text	1 to 2,147,483,647 characters	Text	1 to 104,857,600 characters
Timestamp	8 bytes	Binary	1 to 104,857,600 bytes
Tinyint	0 to 255	Small Integer	Precision 5, scale 0
Varbinary(L)	1 to 8,000 bytes	Binary	1 to 104,857,600 bytes
Varchar(L)	1 to 8,000 characters	String	1 to 104,857,600 characters