SQL CE Max Length
c#, silverlight, sql-server-ce, windows-phone-7
Solution
The 4000 byte limit is imposed on `varchar` fields.
If you want more then you'll need ot use `ntext`.
See the list of supported types at http://msdn.microsoft.com/en-us/library/ms172424(SQL.110).aspx
Problem
I need to store articles in an application for WP7. I just want to use a database so I can query by unread articles, etc, etc. I've run into one big problem with SQL CE in Mango-- there seems to be a limit of 4000 characters, and my article is 4200. And that isn't even the biggest one. How can I get around this limit, if at all? If not, will I have to use a different database or possibly just write stories to IsolatedStorage and manage the file references in the database?