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
char. I guess I could tackle this through the usage of
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.
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.