DATA TYPES – MAPPING from MS SQL TO HANA
Werbung
DATA TYPES – MAPPING from MS SQL TO HANA Find below the default mapping from supported MS SQL data types to HANA data types: MSSQL DATA TYPE SAP (SLT) DATA TYPE HANA DATA TYPE VARCHAR CHAR NVARCHAR CHAR CHAR NVARCHAR NVARCHAR CHAR NVARCHAR NCHAR CHAR NVARCHAR TEXT STRG NCLOB NTEXT STRG NCLOB DATETIME CHAR(23) NVARCHAR(23) SMALLDATETIME CHAR(19) NVARCHAR(19) DATE CHAR(10) NVARCHAR(10) TIME CHAR(16) NVARCHAR(16) BINARY RAW BLOB VARBINARY RAW BLOB IMAGE RSTR BLOB INT INT4 INTEGER SMALLINT INT2 SMALLINT TINYINT INT1 SMALLINT BIGINT DEC DECIMAL BIT INT1 SMALLINT MONEY DEC DECIMAL SMALLMONEY DEC DECIMAL DECIMAL OR NUMERIC FLTP DOUBLE (p=0 or p>31, s=0) *p – precision, s - scale DECIMAL OR NUMERIC INT1 SMALLINT INT2 SMALLINT INT4 INTEGER DEC DECIMAL DEC DECIMAL FLTP DOUBLE FLOAT FLTP DOUBLE REAL FLTP DOUBLE (p<=2, s=0) DECIMAL OR NUMERIC (2<p<=4, s=0) DECIMAL OR NUMERIC (4<p<=9, s=0) DECIMAL OR NUMERIC (9<p<=31, s=0) DECIMAL OR NUMERIC (p<=31, 0<s<=14) DECIMAL OR NUMERIC (all others)
