Conversion Rules

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

JSON stored as text, BSON, or UBJSON can contain specific data types depending on the storage format specification. The following table lists all extended data types of each binary storage specification and their corresponding representation in all other specifications.

Source Specification Source Type Target Specification Target Type
BSON Floating Point JSON number
UBJSON float32/float64
Binary Data JSON/UBJSON

Key/value pair:

{"$type": <string representing type of binary data>,
 "$binary": <string representing binary data>}
ObjectId JSON/UBJSON

Key/value pair:

{"$oid": <string representing object id>}
UTC datetime JSON/UBJSON

Key/value pair:

{"$date": <number representing date>}
Regular Expression JSON/UBJSON

Key/value pair:

{"$regex": < string representing regex>,
 "$options": <string representing options>}
DBPointer JSON/UBJSON

Key/value pair:

{"$ref": <string representing collection>,
 "$id": <string representing object id>}
JavaScriptCode JSON/UBJSON string
Symbol JSON/UBJSON string
JavaScript Code with scope JSON/UBJSON string
TimeStamp JSON/UBJSON

Key/value pair:

{"$timestamp": {
 "$t": <number representing timestamp>,
"$i": <number representing increment>} }
Min key JSON/UBJSON

Key/value pair:

{"$minKey": 1}
Max key JSON/UBJSON

Key/value pair:

{"$maxKey": 1}
int32 JSON number
UBJSON int32
int64 JSON number
UBJSON int64
UBJSON int8 JSON number
BSON int32
int16 JSON number
BSON int32
int32 JSON number
BSON int32
int64 JSON number
BSON int64
float32 JSON number
BSON double
float64 JSON number
BSON double
High-Precision Number JSON/BSON string
char JSON/BSON string