Background documentationData Type Locate this document in the navigation structure

 

The data type specifies which values a table column is allowed to contain.

SAP MaxDB Data Types

Data Type

Description in SQL Reference Manual

BOOLEAN

Boolean

CHAR[ACTER] (ASCII, BYTE, UNICODE)

CHAR[ACTER]

DATE

DATE (date value)

FIXED

FIXED

FLOAT

FLOAT

INT[EGER]

INT[EGER]

CLOB [ASCII]

CLOB UNICODE

BLOB

LOB Column

In earlier database versions, this data type was known as LONG.

SMALLINT

SMALLINT

TIME

TIME (time value)

TIMESTAMP

TIMESTAMP (time stamp value)

VARCHAR (ASCII, BYTE, UNICODE)

VARCHAR

More Information

SQL Reference Manual, Data Type (data_type)

Database Studio, Creating Columns