This shows you the differences between two versions of the page.
|
admin:indexing:text:clob [2011/01/25 17:31] 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 | 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 <sup>1</sup> | | ||
| - | |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 <sup>2</sup> | | ||
| - | |\\ **Update Characteristics** ||||| | ||
| - | |Inserts, updates and deletes | Yes | Yes | Yes | No | | ||
| - | |--------------------------------------------------------------------------|----------------|----------------|----------------|----------------| | ||
| - | |||
| - | <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}} | ||