15.10 - Standards Compliance - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K

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.