NEW JSON ( [ JSON_string_spec | JSON_binary_data_spec ] )
Syntax Elements
- JSON_string_spec
'JSON_String' [, { LATIN | UNICODE | BSON | UBJSON } ]
- JSON_binary_data_spec
'JSON_binary_data' [, { BSON | UBJSON } ]
- 'JSON_String'
- A text string for the value of the resulting JSON instance.
- The string must conform to JSON syntax as described in JSON String Syntax.
- LATIN
- UNICODE
- The character set of the resulting JSON instance.
- If you do not specify a character set, the default character set of the user is used.
- BSON
- UBJSON
- The storage format of the resulting JSON instance.
- The result of the constructor is a JSON type with its data stored in either BSON or UBJSON format.
- JSON_binary_data
- JSON binary data for the value of the resulting JSON instance.
- The binary data must be BYTE, VARBYTE, or BLOB type.
- If you specify JSON_binary_data, you must specify either BSON or UBJSON.