microsoft / ODBC-Specification

Microsoft ODBC Specification
Other
121 stars 40 forks source link

Can collection-valued columns be null, or just empty? #37

Closed mikepizzo closed 6 years ago

mikepizzo commented 6 years ago

The API can represent either null values or collections with no members. Seems arbitrary to disallow null collection values.

Supporting null collections (as well as empty collections) would provide greater fidelity with formats like JSON that have different representations for null arrays versus empty arrays..

Proposal: Allow collection-valued properties to be null.