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, byte, and varbyte. 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: 12/19/2024