Background documentation Data Type Locate the document in its SAP Library structure

The SQL syntax elements for Oracle Version 7 and SAP DB Version 7.4 in Structure linkSQL mode ORACLE differ, among other things, in the definition of data types.

·        In contrast to Oracle, columns with the Structure linkdata type Structure linkCHAR[ACTER] are only stored up to a length of 30 characters with fixed length in SAP DB.

·        The Oracle data type VARCHAR2 does not differ from Structure linkVARCHAR in SAP DB.

·        The data types Structure linkINT[EGER] and Structure linkSMALLINT have 20 significant digits in SAP DB.

·        In SAP DB, the data type Structure linkFLOAT is always represented with 20 significant digits.

·        In SAP DB, data types cannot be defined for numbers with a negative scale. It is not possible to specify a scale that is greater than the number of significant digits.

·        In SAP DB, numbers are not implicitly converted into Structure linkdate values or vice versa.

·        In Oracle, date values extend from 1.1.4712 BC to 31.12.4712 AD.
In SAP DB, date values extend from 1.1.0001 to 31.12.9999.

·        SAP DB does not support the comparison of Structure linkcharacter strings denoted as "non padded comparison" in Oracle.

·        The data types NCHAR, NVARCHAR2, MLSLABEL, BLOB, CLOB, NCLOB, BFILE, and UROWID, which are supported by Oracle, are not supported by SAP DB.