15.10 - Standards Compliance - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

The Teradata JSON data type is compliant with the standard for JSON syntax defined by IETF RFC 4627. The standard is available at http://www.ietf.org/rfc/rfc4627.txt and http://www.json.org/.

The Teradata implementation of the BSON storage format for the JSON type is compliant with the BSON specification located at http://bsonspec.org/.

The Teradata implementation of the UBJSON storage format deviates slightly from the UBJSON specification located at http://ubjson.org/. The proposed UBJSON standard specifies that numeric types are stored in big-endian format. However, Teradata stores the data in little-endian format to optimize insertion and retrieval times.