This is an old revision of the document!
Characteristics | CHAR | C STRING | VARCHAR | CLOB |
---|---|---|---|---|
Datatype Characteristics |
||||
Character data allowed | Yes | Yes | Yes | Yes |
Binary data allowed | No | No | No | No |
Embedded nulls allowed | No | No | Yes | Yes |
Null-terminated | No | Yes | No | No |
Data_lengths required | No | No | Yes | Yes |
Max size | 4,095 | 64mb | 4,095 | 64mb |
Usage Characteristics |
||||
Select item of simple query | Yes | Yes | Yes | Yes |
Select item of outer query | Yes | Yes | Yes | Yes |
Select item of nested query | Yes | Yes | Yes | No |
Select item of INSERT | Yes | Yes | Yes | No |
Select item of set operation | Yes | Yes | Yes | Yes |
Table joins | Yes | Yes | Yes | No |
WHERE clause | Yes | Yes | Yes | Limited 1 |
GROUP BY clause | Yes | Yes | Yes | No |
ORDER BY clause | Yes | Yes | Yes | No |
HAVING clause | Yes | Yes | Yes | No |
SELECT INTO clause | Yes | Yes | Yes | No |
Aggregate functions | Yes | Yes | Yes | No |
SQL Functions | Yes | Yes | Yes | Limited 2 |
Update Characteristics |
||||
Inserts, updates and deletes | Yes | Yes | Yes | No |
————————————————————————– | —————- | —————- | —————- | —————- |
1. Limited to use of LIKE, $CONTAINS and IS NULL operators.
2.See individual functions for compatibility with CLOB datatype.
See also: