Hi All,
I am using a SQLCE 3.5 database (.sdf file), but when I save data this error: "sql truncated conversion error".
byte[] appointmentBytes = app.Save();MyDataRow["AllProperties"] = appointmentBytes;ERROR: --> MyAppointmentsTableAdapter.Update(this.MyDataSet.Appointments);
Any suggestions?
Perhaps I found what causes this error ...With the SQL Server CE the "AllProprieties" field must not be "varbinary" (2048) but "Image" (16)Can someone confirm this?
MSDN Library: *************Supported Data Types and Data Type Mappings for SQL Server 3.5 CE (varbinary) If the length of the data is 510 bytes or less, SQL Server CE replication maps the SQL Server varbinary data to SQL Server CE varbinary ; otherwise, it maps it to SQL Server CE image. If the length of the image data exceeds the length of the varbinary column, synchronization fails when the data is sent from the SQL Server CE subscription to the SQL Server publication.******************************