What data type should be correct to store JSON content as string?

user_1118485 0
Viewed 2179

I plan to use JSON.NET to serialize and deserialize objects to and with the json string store it in the database.

What datatype of the SQL Server 2008 should be the best to store it?

  • nvarchar(max)?
  • varchar(max)?
json.net sql-server-2005 sql-server-2008 sql-server json
3 Answers
Related