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

Database Studio, Creating Columns

SQL Reference Manual, Data Type (data_type)

Loader, Data Types