TDS Fixed-Length Data Types
Fixed-Length Data Types
Note that these fixed-length data types are all 1 byte in length.
Note that these fixed-length data types are all 1 byte in length.
NULLTYPE = 0x1F ; Null (no data associated with this type)
INT1TYPE = 0x30 ; TinyInt (1 byte data representation)
BITTYPE = 0x32 ; Bit (1 byte data representation)
INT2TYPE = 0x34 ; SmallInt (2 byte data representation)
INT4TYPE = 0x38 ; Int (4 byte data representation)
DATETIM4TYPE = 0x3A ; SmallDateTime (4 byte data
representation)
FLT4TYPE = 0x3B ; Real (4 byte data representation)
MONEYTYPE = 0x3C ; Money (8 byte data representation)
DATETIMETYPE = 0x3D ; DateTime (8 byte data representation)
FLT8TYPE = 0x3E ; Float (8 byte data representation)
MONEY4TYPE = 0x7A ; SmallMoney (4 byte data representation)
INT8TYPE = 0x7F ; BigInt (8 byte data representation)