Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0213:
The specification states the following:
-
Subclause 5.3, "<literal>": <binary string literal> ::= X <quote> [ <space>... ] [ { <hexit> [ <space>... ] <hexit> [ <space>... ] }... ] <quote> [ { <separator> <quote> [ <space>... ] [ { <hexit> [ <space>... ] <hexit> [ <space>... ] }... ] <quote> }... ] <hexit> ::= <digit> | A | B | C | D | E | F | a | b | c | d | e | f ... Conformance Rules Without Feature T041, "Basic LOB data type support", or Feature T021, "BINARY and VARBINARY data types", conforming SQL language shall not contain a <binary string literal>. Subclause 6.1, "<data type>": <data type> ::= <predefined type> | <row type> | <path-resolved user-defined type name> | <reference type> | <collection type> ... <character large object type> ::= CHARACTER LARGE OBJECT [ <left paren> <character large object length> <right paren> ] | CHAR LARGE OBJECT [ <left paren> <character large object length> <right paren> ] | CLOB [ <left paren> <character large object length> <right paren> ] ... <national character large object type> ::= NATIONAL CHARACTER LARGE OBJECT [ <left paren> <character large object length> <right paren> ] | NCHAR LARGE OBJECT [ <left paren> <character large object length> <right paren> ] | NCLOB [ <left paren> <character large object length> <right paren> ] ... <binary large object string type> ::= BINARY LARGE OBJECT [ <left paren> <large object length> <right paren> ] | BLOB [ <left paren> <large object length> <right paren> ] ... Conformance Rules Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <binary large object string type>, a <character large object type>, or a <national character large object type>. Subclause 11.60, "<SQL-invoked routine>": <parameter type> ::= <data type> [ <locator indication> ] <locator indication> ::= AS LOCATOR ... <returns data type> ::= <data type> [ <locator indication> ] ... Conformance Rules Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <parameter type> that contains a <locator indication> and that simply contains a <data type> that identifies a large object type. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <returns data type> that contains a <locator indication> and that simply contains a <data type> that identifies a large object type. Subclause 21.3, "<embedded SQL Ada program>": <Ada CLOB variable> ::= SQL TYPE IS CLOB <left paren> <character large object length> <right paren> [ CHARACTER SET [ IS ] <character set specification> ] <Ada CLOB locator variable> ::= SQL TYPE IS CLOB AS LOCATOR ... <Ada BLOB variable> ::= SQL TYPE IS BLOB <left paren> <large object length> <right paren> <Ada BLOB locator variable> ::= SQL TYPE IS BLOB AS LOCATOR ... Conformance Rules Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain an <Ada BLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain an <Ada CLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain an <Ada BLOB locator variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain an <Ada CLOB locator variable>. Subclause 21.4, "<embedded SQL C program>": <C CLOB variable> ::= SQL TYPE IS CLOB <left paren> <character large object length> <right paren> [ CHARACTER SET [ IS ] <character set specification> ] <C host identifier> [ <C initial value> ] [ { <comma> <C host identifier> [ <C initial value> ] }... ] ... <C BLOB variable> ::= SQL TYPE IS BLOB <left paren> <large object length> <right paren> <C host identifier> [ <C initial value> ] [ { <comma> <C host identifier> [ <C initial value> ] } ... ] <C CLOB locator variable> ::= SQL TYPE IS CLOB AS LOCATOR <C host identifier> [ <C initial value> ] [ { <comma> <C host identifier> [ <C initial value> ] } ... ] <C BLOB locator variable> ::= SQL TYPE IS BLOB AS LOCATOR <C host identifier> [ <C initial value> ] [ { <comma> <C host identifier> [ <C initial value> ] } ... ] ... Conformance Rules Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <C BLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <C CLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <C BLOB locator variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <C CLOB locator variable>. Subclause 21.5, "<embedded SQL COBOL program>": <COBOL CLOB variable> ::= [ USAGE [ IS ] ] SQL TYPE IS CLOB <left paren> <character large object length> <right paren> [ CHARACTER SET [ IS ] <character set specification> ] ... <COBOL BLOB variable> ::= [ USAGE [ IS ] ] SQL TYPE IS BLOB <left paren> <large object length> <right paren> ... <COBOL CLOB locator variable> ::= [ USAGE [ IS ] ] SQL TYPE IS CLOB AS LOCATOR <COBOL BLOB locator variable> ::= [ USAGE [ IS ] ] SQL TYPE IS BLOB AS LOCATOR ... Conformance Rules Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <COBOL BLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <COBOL CLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <COBOL BLOB locator variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <COBOL CLOB locator variable>. Subclause 21.6, "<embedded SQL Fortran program>": <Fortran CLOB variable> ::= SQL TYPE IS CLOB <left paren> <character large object length> <right paren> [ CHARACTER SET [ IS ] <character set specification> ] ... <Fortran BLOB variable> ::= SQL TYPE IS BLOB <left paren> <large object length> <right paren> ... <Fortran CLOB locator variable> ::= SQL TYPE IS CLOB AS LOCATOR <Fortran BLOB locator variable> ::= SQL TYPE IS BLOB AS LOCATOR ... Conformance Rules Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <Fortran BLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <Fortran CLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <Fortran BLOB locator variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <Fortran CLOB locator variable>. Subclause 21.7, "<embedded SQL MUMPS program>": <MUMPS CLOB variable> ::= SQL TYPE IS CLOB <left paren> <character large object length> <right paren> [ CHARACTER SET [ IS ] <character set specification> ] ... <MUMPS BLOB variable> ::= SQL TYPE IS BLOB <left paren> <large object length> <right paren> ... <MUMPS CLOB locator variable> ::= SQL TYPE IS CLOB AS LOCATOR <MUMPS BLOB locator variable> ::= SQL TYPE IS BLOB AS LOCATOR ... Conformance Rules Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <MUMPS BLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <MUMPS CLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <MUMPS BLOB locator variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <MUMPS CLOB locator variable>. Subclause 21.8, "<embedded SQL Pascal program>": <Pascal CLOB variable> ::= SQL TYPE IS CLOB <left paren> <character large object length> <right paren> [ CHARACTER SET [ IS ] <character set specification> ] ... <Pascal BLOB variable> ::= SQL TYPE IS BLOB <left paren> <large object length> <right paren> <Pascal CLOB locator variable> ::= SQL TYPE IS CLOB AS LOCATOR ... <Pascal BLOB locator variable> ::= SQL TYPE IS BLOB AS LOCATOR ... Conformance Rules Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <Pascal BLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <Pascal CLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <Pascal BLOB locator variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <Pascal BLOB variable>, <Pascal CLOB variable>, <Pascal CLOB locator variable>. Subclause 21.9, "<embedded SQL PL/I program>": <PL/I CLOB variable> ::= SQL TYPE IS CLOB <left paren> <character large object length> <right paren> [ CHARACTER SET [ IS ] <character set specification> ] ... <PL/I BLOB variable> ::= SQL TYPE IS BLOB <left paren> <large object length> <right paren> ... <PL/I CLOB locator variable> ::= SQL TYPE IS CLOB AS LOCATOR <PL/I BLOB locator variable> ::= SQL TYPE IS BLOB AS LOCATOR ... Conformance Rules Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <PL/I BLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <PL/I CLOB variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <PL/I BLOB locator variable>. Without Feature T041, "Basic LOB data type support", conforming SQL language shall not contain a <PL/I CLOB locator variable>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support the large object (LOB) data type. See the VARBINARY [MSDN-binaryvarbinary] and VARCHAR [MSDN-charvarchar] or deprecated IMAGE and TEXT [MSDN-ntexttextimage] data types for equivalent functionality.