Fabio, my point is: if SQLServer is changed to always call SetParameterSizes and SetParameter does not specify the size, NH will simply default to nvarchar(4000), so what's the problem?
On Oct 28, 10:27 pm, Fabio Maulo <[email protected]> wrote: > no if prepare_sql=false > have a look to the query by your self. > > 2009/10/28 zvolkov <[email protected]> > > > > > > > In your example below, what happens if I don't specify size in > > SetParameter? Will it use vnvarchar(4000) by default? > > > On Oct 28, 6:25 pm, Fabio Maulo <[email protected]> wrote: > > > No problem but write in your post that what you are saying is YOUR > > > interpretation of the story. > > > We can't force, by default, each user to set the parameter dimension in > > each > > > query. > > > Who set prepare-sql=true must know that, at the same time, he must change > > > his way to write a query and he must set the right size in each query. > > > select p from Person where p.Name || p.Surname = :pFullName > > > which is the size of the parameter ? > > > > Now think about what each user should do with his existing project if we > > > will make that behaviour the default only because a MsSQL issue. > > > Who serve who ? > > > The RDBMS serve us or we should serve de RDBMS ? > > > > If your choice is "serve MsSQL" we are giving you the way to do that (and > > > its very easy, as I showed above). > > > > 2009/10/28 zvolkov <[email protected]> > > > > > Fabio, this was my interpretation of your comment on NH-1713: "NH-1707 > > > > was reverted because, more than our work, it mean additional attention > > > > by the user when he create a query (each parameter may need additional > > > > info)... is better if the user set prepare_sql explicitly". My > > > > apologies if what you meant was different from how I understood it. > > > > > On Oct 28, 6:02 pm, Fabio Maulo <[email protected]> wrote: > > > > > I don't know where you read or saw part of your story. > > > > > Try to implement that Drive and le me knoe what you must do when you > > are > > > > > setting the parameters of each query (NHQ and Criteria). > > > > > After that let me know who are doing it in each query. > > > > > > 2009/10/28 zvolkov <[email protected]> > > > > > > > Blogged: NHibernate parameter sizes controversy, history of the > > issue > > >http://zvolkov.com/blog/post/2009/10/28/NHibernate-parameter-sizes-co. > > > > .. > > > > > > -- > > > > > Fabio Maulo > > > > -- > > > Fabio Maulo > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
