Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Microsoft SQL Server and Transformation Datatypes

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


Updated June 25, 2018