>I don't get this one...
>
>Using SQL 2005 Express
>
>I'm getting a "Error Message: String or Binary data would be truncated" in both the VS 2005 IDE and the SQL Server Management Studio (Dev Version) when I try and edit or delete a record.
>
>The field that is causing the error is a ntext field that contains the HTMLBody of some emails. There is no way the data is too long for the field, besides... it's already in the field.
>
>VFP Edits the records just fine :P
>
>Anyone know is this a limitation of the above mentioned editors, or do I have something objectionable in the field? Something setup wrong?
Fixed the database.
It looks like outlook has null characters in it's data. I added a .Replace("\0","") to the strings when they are being inserted. We'll see if that fixes it.