nvarchar(max) is a better performance option On Fri, May 22, 2009 at 5:52 PM, Bill Barry <[email protected]> wrote:
> StringClob should really map to NTEXT, not nvarchar(max) (although I am > not sure what the difference is post sql 2005) > > Krzysztof Koźmic wrote: > > I don't know about AR, but in bare NH you can set sql-type to > varchar(max) (see here: > http://kozmic.pl/archive/2009/05/19/storing-long-text-and-binary-blobs-with-nhibernate.aspx) > > Also you may set length=4001 to achieave the same effect. > > Krzysztof > > Chris Sims pisze: > > > I am using Castle ActiveRecord accessing an MS Sql 2005 DB. I need a > Text field, but when I use the following code: > > [Property(ColumnType="StringClob", Column = > "products_description")] > public String Description { get; set; } > > The column ends up being created as a varchar(255). What am I doing > wrong and how do I resolve this issue? > > Thank you! > Chris Sims > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" 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/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
