SQL CE Max Length

c# silverlight windows-phone-7 sql-server-ce
Andrew M picture Andrew M · Jul 18, 2011 · Viewed 14.4k times · Source

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?

Answer

Matt Lacey picture Matt Lacey · Jul 18, 2011

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

Related questions

How to trigger event when a variable's value is changed?

I'm currently creating an application in C# using Visual Studio. I want to create some code so that when a variable has a value of 1 then a certain piece of code is carried out. I know that I can use …

Read More
Image from URL to stream

I'm getting images from a url: BitmapImage image = new BitmapImage(new Uri(article.ImageURL)); NLBI.Thumbnail.Source = image; This works perfect, now i need to put it in a stream, to make it into byte array. I'm doing this: WriteableBitmap …

Read More
How to use String in WebClient.DownloadStringAsync URL

I currently have this for my WebClient URL WebClient Detail = new WebClient(); Detail.DownloadStringCompleted += new DownloadStringCompletedEventHandler(Detail_DownloadStringCompleted); Detail.DownloadStringAsync(new Uri("http://api.trademe.co.nz/v1/Listings/" + ListingID.Text + ".xml")); What I want to do is use this …

Read More