8.5.2.10 Data Type Mapping

The following type mapping governs the usage of property variables and literals within a content repository SQL statement.

Property type

SQL type

STRING

VARCHAR

BINARY

BINARY

DOUBLE

DOUBLE

LONG

BIGINT

BOOLEAN

BIT

DATE

DATE

NAME

VARCHAR (namespace aware)

PATH

VARCHAR (namespace aware)

REFERENCE

CHAR(36)