If the JSON data is not huge, we can go for NVARCHAR(4000), or else we can go for NVARCHAR(max) for performance reasons. By using nvarchar(max) data type, we can store JSON documents with a max capacity of 2 GB in size. Raw JSON documents have to be parsed, and they may contain Non-English text. JSON documents can be stored as-is in NVARCHAR columns either in LOB storage format or Relational storage format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |