Share via


2.1.2.189 T061, UCS support

V0225:

The specification states the following:

 Subclause 6.1, "<data type>":
  
 <character length> ::=
 <unsigned integer> [ <char length units> ]
  
 ...
  
 <character large object length> ::=
 <large object length> [ <char length units> ]
  
 <char length units> ::=
 CHARACTERS
 | OCTETS
  
 ...
  
 Conformance Rules
  
 Without Feature T061, "UCS support", conforming SQL language shall not contain a <char length units>.
  
 Subclause 6.30, "<string value function>":
  
 <normalize function> ::=
 NORMALIZE <left paren> <character value expression>
 [ <comma> <normal form> [ <comma> <normalize function result length> ] ] <right paren>
  
 <normal form> ::=
 NFC
 | NFD
 | NFKC
 | NFKD
  
 <normalize function result length> ::=
 <character length>
 | <character large object length>
  
 ...
  
 Conformance Rules
  
 Without Feature T061, "UCS support", conforming SQL language shall not contain a <normalize function>.
  
 Subclause 8.12, "<normalized predicate>":
  
 <normalized predicate> ::=
 <row value predicand> <normalized predicate part 2>
  
 <normalized predicate part 2> ::=
 IS [ NOT ] [ <normal form> ] NORMALIZED
  
 ...
  
 Conformance Rules
  
 Without Feature T061, "UCS support", conforming SQL language shall not contain a <normalized predicate>.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.