Administration: Chapter

Topic

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 ¹
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 ²
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.}

Prev | Next