Comparision of JSON Data Types across Database Products

As per

JSON is on the rise, so here is an initial comparision of JSON data types across data products, more to follow

SQL Server

SQL Server 2016 preview – No native JSON data type, NVARCHAR used instead, no indexing



JSON/JSONB data types

Waiting for 9.4 – Introduce jsonb, a structured format for storing json.

JSONB “Insignificant whitespace is discarded, and the order of object keys is not
preserved. Neither are duplicate object keys kept – the later value for a given
key is the only one stored.”


JSON / BSON data types


Native JSON/BSON data types, indexing supported, JSON sharding across a cluster of data servers supported.Wire listener supported for Mongo DB applications to talk to Informix via MongoDB community drivers and the REST API.

JSON/BSON data types

Indexing a BSON field

BSON processing functions

JSON data sharding

Wire listener which handles Mongo API wire protocol



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s