2.1.5 Binary XML

When using TCP or HTTP/HTTPS as the transport, the client and server SHOULD choose to encode messages in binary XML [MS-BINXML]. This is first negotiated when the connection is established.

The following table lists the binary XML data types that are supported in this protocol. The client and server MUST NOT use data types outside this list.

XSD Type

Binary XML Type

xsd:boolean

XSD-BOOLEAN

xsd:byte

SQL-TINYINT

xsd:short

SQL-SMALLINT

xsd:int

SQL-INT

xsd:long

SQL-BIGINT

xsd:unsignedByte

XSD-BYTE

xsd:unsignedShort

XSD-UNSIGNEDSHORT

xsd:unsignedInt

XSD-UNSIGNEDINT

xsd:unsignedLong

XSD-UNSIGNEDLONG

xsd:double

SQL-REAL

xsd:float

SQL-FLOAT

xsd:decimal

SQL-MONEY

xsd:dateTime

SQL-DATETIME

uuid

SQL-UUID

xsd:string

SQL-NTEXT

SQL-NCHAR

SQL-NVARCHAR

xsd:base64Binary

SQL-BINARY