Was this helpful?
Data Types
JSON does not use a unique data type. JSON values and objects can be stored in any string column: char, varchar, nchar, nvarchar. A database column containing JSON data looks and acts like a normal “non-JSON” column and can store a mix of JSON data and non-JSON data. When running JSON queries or expressions, however, JSON uses its own set of data types. A JSON value can have the following data types:
JSON scalar
JSON array
JSON object
Last modified date: 03/21/2024