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) |