1.1.1

NoteSQL-2003
Optional
SQL-99
Outside
Core
Feature nameFeature
ID
NoNoTimestamp in Information SchemaT011
NoNoBOOLEAN data typeT031
YesYesBasic LOB data type supportT041
YesYesBLOB data type – Subclause 5.2,
"<token> and <separator>": The
T041-01
<reserved word>s BINARY, BLOB,
LARGE, and OBJECT – Subclause
5.3, "<literal>": <binary string
literal> -- Subclause 6.1, "<data
type>": The BINARY LARGE
OBJECT data type – Subclause 6.28,
"<string value expression>": For
values of type BINARY LARGE
OBJECT – Subclause 13.6, "Data
type correspondences": Type
correspondences for BINARY
LARGE OBJECT for all supported
languages
YesYesCLOB data type – Subclause 5.2,
"<token> and <separator>": The
T041-02
<reserved word>s CHARACTER,
CLOB, LARGE, and OBJECT –
Subclause 6.1, "<data type>": The
CHARACTER LARGE OBJECT
data type – Subclause 6.28, "<string
value expression>": For values of
type CHARACTER LARGE
OBJECT – Subclause 13.6, "Data
type correspondences": Type
correspondences for CHARACTER
LARGE OBJECT for all supported
languages – The implicit casting
among the fixed-length and
variable-length character string types
supported by subfeature E021-10 is
extended to support the character
large object type
Not standard SQL syntax. See notes on features
E021-04, E021-06, E021-09 and E021-11
Yes*Yes*POSITION, LENGTH, LOWER,
TRIM, UPPER, and SUBSTRING
functions for LOB data types –
T041-03
Subclause 6.27, "<numeric value
function>": The <position
expression> for expressions of type
BINARY LARGE OBJECT and
CHARACTER LARGE OBJECT –
Subclause 6.27, "<numeric value
function>": The <char length
649
SQL Language Reference