Standards Compliance

Teradata Vantageā„¢ JSON Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K

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.