varchar(max) and varbinary(max) length problem in SQL CE 3.5 sp1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Habib - 17 Jul 2008 15:06 GMT

We are currently have a problem with a new application, where we are using
the Entity Framework (Visual Studio 2008 SP1 beta), which only uses the
latest version of SQLCE 3.5 sp1 to read / update SQL Compact edition. This
currently is for a desktop application.

It seems that it is limited to only 8K of binary data, and 4K of text data.
We are using varchar(max) and varbinary(max).

Do you know of any hotfixes we could have to fix these problems, or who we
should be approaching to get help in these matters ?

Thanks

haib

Reply to this Message

Laxmi Narsimha Rao Oruganti [MSFT] - 17 Jul 2008 16:54 GMT

Are not types 'image' and 'ntext' do the job for you?

Thanks,
Laxmi [Disclaimer: All postings are as-is and confer no rights]

> We are currently have a problem with a new application, where we are using
> the Entity Framework (Visual Studio 2008 SP1 beta), which only uses the
[quoted text clipped - 12 lines]
>
> haib

Reply to this Message

Habib - 18 Jul 2008 16:46 GMT

Thanks Laxmi,

It worked for me when i store image and text directly to the sql ce 3.5
database. But its still not working with entity framework.

Thanks

Signature

haib

> Are not types 'image' and 'ntext' do the job for you?
>
[quoted text clipped - 17 lines]
> >
> > haib

Reply to this Message

Laxmi Narsimha Rao Oruganti [MSFT] - 21 Jul 2008 06:58 GMT

I just confirmed with dev and in final release bits, you should find this
working.

Thanks,
Laxmi

> Thanks Laxmi,
>
[quoted text clipped - 26 lines]
>> >
>> > haib

Reply to this Message