Specifies whether the name/value pairs within JSON objects are sorted lexicographically.

Data Type

bool

Default Value

false

Remarks

When this property is set to true, the driver sorts the name/value pairs of all JSON objects lexicographically by their key names. Sorting applies to all unflattened JSON objects, regardless of their nesting depth.

When this property is set to false, name/value pairs retain their original order as defined in the JSON document.

This property has no effect when BackwardsCompatibilityMode is set to true.

This property is useful for ensuring consistent column order and predictable output when reading JSON data from sources that do not guarantee key order.