SQL Reference Guide > SQL Reference Guide > Working with JSON Data
Was this helpful?
Working with JSON Data
 
Data Types
JSON Concepts
JSON Constructors
JSON Query Functions
Use of Operators with JSON Data
JSON Item Methods
 
JSON (JavaScript Object Notation) is an easy to read, flexible, and lightweight method for sharing between applications. The unstructured nature of JSON objects means that data can be stored in a database table without requiring a predetermined schema. JSON objects inserted into a database can use whatever keys they wish, which allows applications to store new data without requiring database changes.
Actian X lets you store, access, and generate JSON data.
The JSON implementation in Actian X is compliant with the JSON ISO standard.
JSON works against Unicode data and requires using a UTF8 character set.
Note:  JSON is not supported for X100 tables. JSON data can be stored as strings within X100 tables; however JSON constructors, functions, and item methods do not run against X100 tables.
Last modified date: 11/09/2022