Storing a json string that is 10 kb in size in a SQL Server CE cell
0
votes
1
answer
624
views
I have a SQL Server CE database in which I have column that takes values of json strings. These json strings are above 9kb as a result of which I am unable to use
varchar
or char
. I guess I could tackle this through the usage of ntext
.
But in SQL Server, this is marked to be removed in an upcoming edition. I am not sure of SQL Server CE. Also I am having where and having conditions / statements on other values stored in this column.
Therefore having ntext
may not help as well. Are there any other data types that I could use to store this json string? Any help would be much appreciated.
Asked by AnOldSoul
(471 rep)
Mar 16, 2017, 05:05 AM
Last activity: Mar 16, 2017, 01:10 PM
Last activity: Mar 16, 2017, 01:10 PM