Do .NET tableadapters truncate strings?
Posted on 2009-05-14
I'm having trouble figuring out the following so would appreciate some help...
I have a TableAdapter set up that includes an insert query to insert a lot of text data into a field in my database. However, it seems that the string is truncated to 1024 characters every time. I've checked external factors (IIS, sceurity, etc) and ruled those out - not least because another program using the same services CAN post >1024 chars - so that leaves my code.
I've checked that the data is not truncated in my code (it's stored as a string) and it is not.
The field is set up as a system.string in the tableadapter with a max length of 2147483647
The field is set up in my DB as a text
Why would the data get truncated? Is there an issue in .NET (v2 by the way) or in what I've done? Any advice greatly appreciated...