This shows you the differences between two versions of the page.
admin:indexing:text:clob [2011/01/25 17:19] els created |
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 | | | | | | ||
- | | = 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 | | ||
- | |--------------------------------------------------------------------------|----------------|----------------|----------------|----------------| | ||
- | |||
- | ===== ===== | ||
- | |||
- | **[[prev|Prev]]** | **[[next|Next]]** | ||
- | |||
- | ====== Additional Resources ====== | ||
- | |||
- | See also: | ||
- | |||
- | {{page>:admin:see_also&nofooter&noeditbtn}} | ||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |