JSON Data Type | Rules | VantageCloud Lake - Rules for JSON Data - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
  • JSON allows Unicode characters to be embedded in their hexadecimal formats in a character string using the '\u' string as an escape sequence. However, the '\u' hex Unicode character is not interpreted, but stored as is.
  • White space outside the root of the JSON object or array is trimmed for all instances of the JSON type. White space characters within the root of the JSON object or array are considered significant and are not removed.
  • There is a maximum limit of nesting imposed on a JSON instance. The default is 512.
    A nested object or array counts against this limit.
  • You can specify exponential numbers using scientific notation. The range of valid numbers is between -1e308 and 1e308, noninclusive. Exponents can have a value between -308 and 308, noninclusive. Any number or exponent specified outside of the valid range, whether explicitly stated or understood to be outside of that range based on the value of the mantissa, is an error.