SAP HANA supports a variety of data types to handle different kinds of data efficiently. These data types can be broadly categorized into several groups: 1. Numeric Data Types TINYINT : 1-byte integer (-128 to 127). SMALLINT : 2-byte integer (-32,768 to 32,767). INTEGER : 4-byte integer (-2,147,483,648 to 2,147,483,647). BIGINT : 8-byte integer (-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807). DECIMAL(p,s) : Fixed-point number with precision p and scale s . REAL : Single-precision floating-point number. DOUBLE : Double-precision floating-point number. 2. Character Data Types CHAR(n) : Fixed-length character string with length n . VARCHAR(n) : Variable-length character string with a maximum length n . CLOB : Character Large Object for large text data. 3. Binary Data Types BINARY(n) : Fixed-length binary data with length n . VARBINARY(n) : Variable-length binary data with a maximum length n . BLOB : Binary Large Object for large binary data. 4. Date and Time Data Types DAT...
Comments
Post a Comment