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