2.2.5.4.3 Partially Length-Prefixed Data Types

The data value corresponding to the set of data types defined in this section follows the rule defined in the partially length-prefixed stream definition (section 2.2.5.2.3).

 PARTLENTYPE      =   XMLTYPE
                      /
                      BIGVARCHRTYPE
                      /
                      BIGVARBINTYPE
                      /
                      NVARCHARTYPE
  
                      /
                      UDTTYPE

BIGVARCHRTYPE, BIGVARBINTYPE, and NVARCHARTYPE can represent two types each:

  • The regular type with a known maximum size range from 0 to 8000, defined by USHORTLEN_TYPE.

  • A type with unlimited max size, known as varchar(max), varbinary(max) and nvarchar(max), which has a max size of 0xFFFF, defined by PARTLENTYPE. This class of types was introduced in TDS 7.2.

Show: