This shows you the differences between two versions of the page.
|
admin:indexing:text:clob [2011/01/25 17:25] 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 | | | 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 | Y | Y | Y | Limited((Limited to use of LIKE, $CONTAINS and IS NULL operators)) | | ||
| - | |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((See individual functions for compatibility with CLOB datatype)) | | ||
| - | | | | | | N | | ||
| - | |\\ **Update Characteristics** ||||| | ||
| - | | Inserts, updates and deletes | Y | Y | Y | N | | ||
| - | |--------------------------------------------------------------------------|----------------|----------------|----------------|----------------| | ||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[prev|Prev]]** | **[[next|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:admin:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||