Tagged/delimited string format - NULL handling

NULL handling dictates the way in which the MRM parser for TDS messages handles elements that have been set to Null.

The rules for whether nulls are permitted are described in TDS Null handling options.

Null properties

The element properties Encoding Null and Encoding Null Value control how null handling is represented for individual elements.

You can select the Encoding Null property from the three enumerated values NULLPadFill, NULLLogicalValue, and NULLLiteralValue. The use of the Encoding Null Value property is dependent on the value that you select for the Encoding Null property.

NULL values are not defined for schema xsd:hexBinary simple types. The properties Encoding Null and Encoding Null Value are therefore not set for xsd:hexBinary types.

NULL values for schema boolean simple types are defined at the message set level. The message set property Boolean Null Representation specifies the value to be used for Boolean Null representation.

Related Concepts
Tagged/delimited string format
Data element separation
Tagged/delimited string format - Model integrity
Tagged/delimited string format - Multipart messages
Tagged/delimited string format - Data conversion
Tagged/delimited string format - Relationship to the logical model

Related Tasks
Adding a Tagged/Delimited String (TDS) wire format
Configuring Tagged/Delimited String (TDS) properties: Message sets
Configuring Tagged/Delimited String (TDS) properties: Message model objects

Related Reference
TDS Null handling options
TDS message model integrity
Tagged/delimited string format physical properties for message model objects