2.1.1.3 E021-02, CHARACTER VARYING data type (including all its spellings)

  • Article

V0003:

The specification states the following:

 Subclause 6.1, "<data type>":
  
 <character string type> ::=
 CHARACTER [ <left paren> <character length> <right paren> ]
 | CHAR [ <left paren> <character length> <right paren> ]
 | CHARACTER VARYING <left paren> <character length> <right paren>
 | CHAR VARYING <left paren> <character length> <right paren>
 | VARCHAR <left paren> <character length> <right paren>
 | <character large object type>

Microsoft SQL Server 2008 R2 varies as follows:

Transact-SQL partially supports this feature. The length of the string is specified in bytes, not characters.