JSON Data Type | Overview | Teradata Vantage - JSON Data Type - Advanced SQL Engine - Teradata Database

JSON Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
uwa1591040057999.ditamap
dita:ditavalPath
uwa1591040057999.ditaval
dita:id
B035-1150
lifecycle
previous
Product Category
Teradata Vantageā„¢

The JSON data type is provided by Vantage. You can use it for JSON format data, similarly to how you use other SQL data types.

  • JSON data type content is stored in an optimized format depending on the size of the data.
  • The user is not responsible for executing the CREATE TYPE statement for the JSON data type. JSON data types do not need to be created via DDL by the user as the JSON data type exists in the database.
  • The JSON data type cannot be created, dropped, or altered by the user.
  • There are two points of commonality between all uses of the JSON data type in any valid location:
    • The maximum length of any instance of the JSON data type is variable. You may set the maximum length of the JSON instance, otherwise the default maximum length is used.
    • The CHARACTER SET for the text of the JSON data type can be either UNICODE or LATIN. If you do not specify the character set, the default character set of the user is used.