This shows you the differences between two versions of the page.
admin:indexing:text:clob [2011/01/25 17:29] els |
admin:indexing:text:clob [2016/06/28 22:38] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ~~NOTOC~~ | ||
- | {{page>:top_add&nofooter&noeditbtn}} | ||
- | ====== Administration: Chapter ====== | ||
- | |||
- | ===== Topic ===== | ||
- | |||
- | **[[nav|Nav1]]** | [[nav|Nav2]] | ||
- | |||
- | ---- | ||
- | |||
- | |||
- | |||
- | ==== Subtopic ==== | ||
- | |||
- | ^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 | N | N | Y | Y | | ||
- | |Null-terminated | N | Y | N | N | | ||
- | |Data_lengths required | N | N | 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 | Y | Y | Y | Limited <sup>1</sup> | | ||
- | |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 <sup>2</sup> | | ||
- | |\\ **Update Characteristics** ||||| | ||
- | | Inserts, updates and deletes | Y | Y | Y | N | | ||
- | |--------------------------------------------------------------------------|----------------|----------------|----------------|----------------| | ||
- | |||
- | <sup>1. Limited to use of LIKE, $CONTAINS and IS NULL operators.</sup>\\ | ||
- | <sup>2.See individual functions for compatibility with CLOB datatype.</sup> | ||
- | |||
- | ===== ===== | ||
- | |||
- | **[[prev|Prev]]** | **[[next|Next]]** | ||
- | |||
- | ====== Additional Resources ====== | ||
- | |||
- | See also: | ||
- | |||
- | {{page>:admin:see_also&nofooter&noeditbtn}} | ||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |