http://bugzilla.novell.com/show_bug.cgi?id=609935
http://bugzilla.novell.com/show_bug.cgi?id=609935#c0 Summary: Insert into Sqlserver nvarchar(max) fields truncates data > 4000 characters Classification: Mono Product: Mono: Runtime Version: 2.4.x Platform: 64bit OS/Version: RHEL 5 Status: NEW Severity: Normal Priority: P5 - None Component: misc AssignedTo: [email protected] ReportedBy: [email protected] QAContact: [email protected] Found By: --- Blocker: --- User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.2; WOW64; Trident/4.0) If I define the field as varchar(max) , the insert of this field all gets inserted when its > 4000 characters but when its defined as nvarchar(max) it gets truncated to 4000. Looked at traces, mono its sending the insert using nvarchar(4000). I think microsoft sqlclient driver , detects that the data > 4000 and will will use something like NTEXT as the DBTYPE but Im not sure. Im having problems running mono 2.6 so I cant really test it to see if it addressed in that version though but I searched and couldnt find any reference to this problem. Reproducible: Always Steps to Reproduce: 1. 2. 3. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug. You are the assignee for the bug. _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
