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: