Sample Header Ad - 728x90

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