Share via


2.1.2.173 T022, Advanced support for BINARY and VARBINARY data types

V0209:

The specification states the following:

 Subclause 6.30, "<string value function>":
  
 <binary value function> ::=
 <binary substring function>
 | <binary trim function>
 | <binary overlay function>
  
 ...
  
 Conformance Rules
  
 Without Feature T042, "Extended LOB data type support", or Feature T022, "Advanced support for BINARY and VARBINARY data types", conforming SQL language shall not contain a <binary value function>.
  
 Subclause 8.5, "<like predicate>":
  
 <octet like predicate> ::=
 <row value predicand> <octet like predicate part 2>
  
 <octet like predicate part 2> ::=
 [ NOT ] LIKE <octet pattern> [ ESCAPE <escape octet> ]
  
 <octet pattern> ::=
 <binary value expression>
  
 <escape octet> ::=
 <binary value expression>
  
 ...
  
 Conformance Rules
  
 Without Feature T042, "Extended LOB data type support", or Feature T022, "Advanced support for BINARY and VARBINARY data types", conforming SQL language shall not contain an <octet like predicate>.

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

Transact-SQL does not support this feature.