Microsoft SQL Server to SAP HANA Database

Lists Microsoft SQL Server-to-SAP HANA database datatype mappings.

See SAP HANA Reference > SQL Reference Manual > Data Types for current information on the range of values that can be represented by SAP HANA database datatypes.

Microsoft SQL Server-to-SAP HANA Database Datatype Mappings
Microsoft SQL Server Datatype	Replication Definition Datatype	SAP HANA Database Datatype
`bigdatetime`	`bigdatetime`	`timestamp`
`bigint`	`rs_msss_bigint`	`bigint`
`bigtime`	`bigtime`	No default
`binary`	`binary`	`varbinary`
`bit`	`tinyint`	`tinyint`
`char`	`char`	`varchar` (See note below.)
`date`	`date`	`date`
`datetime`	`rs_msss_datetime`	`timestamp`
`datetime2`	`rs_msss_datetime2`	`timestamp`
`decimal`	`decimal` `varchar`	`decimal` (to 34 digits) `varchar` (over 34 digits)
`double precision`	`float`	`double`
`float`	`float`	`float`
`identity`	`numeric`	`numeric`
`integer`	`rs_msss_bigint`	`bigint`
`image`	`image`	`blob`
`longsysname varchar(255) Not Null`	`varchar(255)`	`varchar(255)`
`money`	`decimal`	`decimal(19,4)`
`nchar`	`unichar`	`nvarchar`
`nvarchar(max)`	`rs_msss_nvarchar_max`	`nclob`
`numeric`	`numeric`	`decimal`
`nvarchar`	`varchar`	`nvarchar`
`real`	`real`	`real`
`smalldatetime`	`rs_msss_datetime`	`seconddate`
`smallint`	`smallint`	`smallint`
`smallmoney`	`decimal`	`decimal(10,4)`
`sysname varchar(30) Not Null`	`varchar(30)`	`varchar(30)`
`text`	`text`	`clob`
`timestamp`	`timestamp`	`varbinary(8)`
`tinyint`	`tinyint`	`tinyint`
`time`	`rs_msss_time`	`timestamp`
`unichar`	`unichar`	`nchar`
`uniqueidentifier`	`char(36)`	`varchar(36)`
`unitext`	`unitext`	`clob`
`univarchar`	`univarchar`	`nvarchar`
`unsigned bigint`		`decimal`
`unsigned int`	`unsigned int`	`bigint`
`unsigned smallint`	`unsigned smallint`	`integer`
`unsigned bigint`	`unsigned bigint`	`decimal`
`varbinary(max)`	`rs_msss_varbinary_max`	`blob`
`varchar(max)`	`rs_msss_varchar_max`	`clob`

Note: If your primary database is configured for a single-byte character set (like iso_1) that accepts extended ASCII characters—the one-byte ASCII character values between 128 and 255—SAP HANA database may convert single-byte extended characters into double-byte characters in char or varchar columns. This conversion may subsequently cause the storage size in SAP HANA database to exceed the original column length or storage of the primary database. If your primary database and application support using extended ASCII characters in a single-byte character set, you may need to increase the size of the corresponding column in the SAP HANA database table definition. This change allows those columns to accommodate the conversion of extended characters to two-byte storage.