This should be documented as a breaking change for NH3 -- I have a number of strings mapped to nvarchar(max) fields today in 2.1.2 that look like <property name="Blah" /> and work fine with large values.
For reference, nvarchar(max) max length is 1,073,741,822 (from http://www.sql-server-helper.com/sql-server-2005/..%5Cfaq%5Csql-server-2005-varchar-max-p01.aspx) Thanks! -Michael On Oct 5, 1:17 pm, srf <[email protected]> wrote: > Ya, I figured so, I tried switching to StringClob and it basically did > what I mentioned and set the size to a really large size and worked so > Im ok with that and will make that change. Just as an thought, would > it be helpfull if when setting the paramter.value we can see that the > if the parameter size is less then the length of the text that it > would get cut off and maybe nhibernate should raise a warning or > exception like "hey your text is going to get cuttoff , are you sure > you want to do this??" or something like that? you would thing > something farther down like ado.net or sqlserver would also flag it > too rather than just cutting it off and continuing like nothing bad > has just happened. > > thanks > > scott > > On Oct 5, 2:05 pm, Ayende Rahien <[email protected]> wrote: > > > > > No, the parameter size should be fixed. That ensures that you have > > consistent query plans. > > Specify that the field type is StringClob in the mapping > > > On Tue, Oct 5, 2010 at 9:54 PM, srf <[email protected]> wrote: > > > I was trying to figure out why things working working anymore in > > > nhibernate 3 and noticed that in nhibernate 2 the dbparameter.size > > > would be set to what the dbparameter.value's length was as long as the > > > dbparameter.size was set to 0. Now in nhibernate 3, the > > > dbparameter.size is getting set because line 164 in SqlClientDriver.cs > > > is commented out so its now by default setting the size to some fixed > > > size rather than setting the size to what the parameter value size is. > > > So I was wondering why that is commented out now. The problem I have > > > is that I have varchar(max) values and the parameter size could be > > > really large so the parameter size need to be set to what the length > > > of the text inserted or sqlserver will just cut it off to whatever the > > > parameter.size is. Is handling really large text like varchar(max) to > > > be done differently? > > > > thanks > > > > scott- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text -
