This is an old revision of the document!
Characteristics | CHAR | C STRING | VARCHAR | CLOB |
---|---|---|---|---|
Datatype Characteristics | ||||
Character data allowed | Y | Y | Y | Y |
Binary data allowed | N | N | N | N |
Embedded nulls allowed | Y | Y | ||
Null-terminated | Y | |||
Data_lengths required | Y | Y | ||
Max size | 4,095 | 64mb | 4,095 | 64mb |
Usage Characteristics | ||||
Select item of simple query | Y | Y | Y | Y |
Select item of outer query | Y | Y | Y | Y |
Select item of nested query | Y | Y | Y | N |
Select item of INSERT | Y | Y | Y | N |
Select item of set operation | Y | Y | Y | Y |
Table joins | Y | Y | Y | N |
WHERE clause | ||||
= operator | Y | Y | Y | N |
IN operator | Y | Y | Y | N |
LIKE operator | Y | Y | Y | Y |
> >= < ⇐ operator | Y | Y | Y | N |
<> or != operator | Y | Y | Y | N |
IS NULL | Y | Y | Y | Y |
$CONTAINS function | Y | Y | Y | Y |
GROUP BY clause | Y | Y | Y | N |
ORDER BY clause | Y | Y | Y | N |
HAVING clause | Y | Y | Y | N |
SELECT INTO clause | Y | Y | Y | N |
Aggregate functions | Y | Y | Y | N |
SQL Functions | Y | Y | Y | Limited |
N | ||||
Update Characteristics | ||||
Inserts, updates and deletes | Y | Y | Y | N |
————————————————————————– | —————- | —————- | —————- | —————- |
See also: