2.1.2.93 F690, Collation support

  • Article

V0129:

The specification states the following:

 Subclause 5.4, "Names and identifiers":
  
 <collation name> ::=
 <schema qualified name>
  
 ...
  
 Conformance Rules
  
 Without Feature F690, "Collation support", conforming SQL language shall not contain a <collation name>.
  
 Subclause 10.7, "<collate clause>":
  
 <collate clause> ::=
 COLLATE <collation name>
  
 ...
  
 Conformance Rules
  
 Without Feature F690, "Collation support", conforming SQL language shall not contain a <collate clause>.
  
 Subclause 11.43, "<collation definition>":
  
 <collation definition> ::=
 CREATE COLLATION <collation name> FOR <character set specification>
 FROM <existing collation name> [ <pad characteristic> ]
  
 <existing collation name> ::=
 <collation name>
  
 <pad characteristic> ::=
 NO PAD
 | PAD SPACE
  
 ...
  
 Conformance Rules
  
 Without Feature F690, "Collation support", conforming SQL language shall not contain a <collation definition>.
  
 Subclause 11.44, "<drop collation statement>":
  
 <drop collation statement> ::=
 DROP COLLATION <collation name> <drop behavior>
  
 ...
  
 Conformance Rules
  
 Without Feature F690, "Collation support", conforming SQL language shall not contain a <drop collation statement>.

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

Transact-SQL partially supports this feature. Transact-SQL supports a COLLATE clause, but does not support the CREATE COLLATION and DROP COLLATION statements.