[Mono-bugs] [Bug 609935] New: Insert into Sqlserver nvarchar(max) fields truncates data > 4000 characters

[bugzilla_noreply at novell.com]

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: mono-bugs at lists.ximian.com
        ReportedBy: srfcanada at hotmail.com
         QAContact: mono-bugs at lists.ximian.com
          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.