insert ntext greater than 8000 chrs using vb.net or c#.net?

[Vinit Bhansali]

Hi,

This is an ongoing problem for my current project.
How do I insert an ntext string into sqlCE database that is greater than
8000 characters?
Also, what is the best way to read in such a long ntext column ?

I am willing to look at a solution in vb.net and/or c#.net for the
compactframework.

Any help will be appreciated,

--
Vinit Bhansali
(e-mail address removed)
www.mindpillar.com
www.logic2go.com
--------------------------------------------

 

[Darren Shaffer]

Vinit,

The ntext data type in SQL CE has a limit of 1,073,741,823 characters.
Not sure what error message you are getting, but it would help if you
could elaborate on the error or problem you're having. Noticed you
also posted this in the sqlce newsgroup, which is probably the best
place for this question. Kevin Collins does a good job of responding
to these issues, but I'm sure he'll also need to know more about
the error you're seeing.

-Darren Shaffer