My DB schema has a string as a varchar(max). I have read the other questions concerning setting Length to more than 4000 or 8000 so that it really generates a (n)varchar(max) in the mapping but when I use Length(10000) in my mapping class, the hbm file actually shows length="10000" and if I save an entity with more than 10000 chars, it is actually truncated to exactly 10000 chars.
I don't want any truncation.
(using NH3-alpha2 and FNH trunk)
It would appear that this is an old problem which is now resurfacing in NHibernate 3.x builds; you can read about the workarounds here.
Note: I have updated the original link I posted as it was outdated.
This mapping should work:
<property name="TheProperty" type="StringClob">
<column name="TheColumn" sql-type="nvarchar(max)" />
</property>
Just look for the fluent equivalent.
DanP's link is broken. The updated link is:
http://www.primordialcode.com/blog/post/nhibernate-prepare_sql-considerations-mapping-long-string-fields
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With