ntext column with 256 chars does not ger synch

[Guest]

Hello all,

I have an SQL table with a ntext column. That column contains data with 256
characters and more. I have also a pocket pc with SQL CE 2.0 with the same
table/column and an ntext datatype. Everytime I sync and the data (SQL
server) in the column has 255 charaters and less the sync will work
successfully. This same column with 256 characters and more will not get sync
on my pocket pc 2003. The row will get created but no data for that column.

Initialy, on the SQL server, my column was a nvarchar(2000), i thought that
could conflict with SQL CE because nvarchar datatype has a max character of
255. But the result didn't change.

I also ran an update statement on the SQL CE DB to make sure the column
could hold more than 255 characters and I was successfull since it's an ntext.

The queries for the sync are being done through http. Could that be the
issue? Is there some sort of configuration that I missed?

NOTE: I'm using appforge.

Any help would be appreciated.

Thanks,

Pat

 

[Alex Feinman [MVP]]

It should work. Are you using RDA or Merge Replication?

 

[Guest]

I'm using replication.

It should work. Are you using RDA or Merge Replication?

 

[Guest]

Sorry I meant to type RDA.

It should work. Are you using RDA or Merge Replication?