Variable-Length Data Types

The data type token values defined in this section have a length value associated with the data type, because the data value corresponding to these data types are represented by a variable number of bytes.

 GUIDTYPE            =   0x24  ; UniqueIdentifier 
 INTNTYPE            =   0x26  ; (see below) 
 DECIMALTYPE         =   0x37  ; Decimal (legacy support) 
 NUMERICTYPE         =   0x3F  ; Numeric (legacy support) 
 BITNTYPE            =   0x68  ; (see below) 
 DECIMALNTYPE        =   0x6A  ; Decimal 
 NUMERICNTYPE        =   0x6C  ; Numeric 
 FLTNTYPE            =   0x6D  ; (see below) 
 MONEYNTYPE          =   0x6E  ; (see below) 
 DATETIMNTYPE        =   0x6F  ; (see below) 
 DATENTYPE           =   0x28  ; (introduced in TDS 7.3) 
 TIMENTYPE           =   0x29  ; (introduced in TDS 7.3) 
 DATETIME2NTYPE      =   0x2a  ; (introduced in TDS 7.3) 
 DATETIMEOFFSETNTYPE =   0x2b  ; (introduced in TDS 7.3) 
 CHARTYPE            =   0x2F  ; Char (legacy support) 
 VARCHARTYPE         =   0x27  ; VarChar (legacy support) 
 BINARYTYPE          =   0x2D  ; Binary (legacy support) 
 VARBINARYTYPE       =   0x25  ; VarBinary (legacy support) 
 BIGVARBINTYPE       =   0xA5  ; VarBinary 
 BIGVARCHRTYPE       =   0xA7  ; VarChar 
 BIGBINARYTYPE       =   0xAD  ; Binary 
 BIGCHARTYPE         =   0xAF  ; Char 
 NVARCHARTYPE        =   0xE7  ; NVarChar 
 NCHARTYPE           =   0xEf  ; NChar 
 XMLTYPE             =   0xF1  ; XML 
 UDTTYPE             =   0xF0  ; CLR-UDT 
 TEXTTYPE            =   0x23  ; Text 
 IMAGETYPE           =   0x22  ; Image 
 NTEXTTYPE           =   0x63  ; NText 
 SSVARIANTTYPE       =   0x62  ; Sql_Variant