I have searched and found one reference to this, but it was deemed "unreproduceable" ( http://jira.nhibernate.org/browse/NH-267 ) I wish I couldn't reproduce it, but it's happening. I have MS SQL 2000 and an object type with an ntext column which is getting truncated to 4000 characters when it saves. SQL Profiler shows only 4000 characters in the INSERT statement... but I've verified that the object has much more than that before NHibernate tries to persist it. The property in my mapping file looks like:

<property name="LongStringVal" type="String">
<column name="LongStringVal" length="1073741823" sql-type="ntext" not-null="false"/>
</property>

Does this really not happen for anyone else? What could I be doing wrong? I've changed the "length" param just to see if it would make a difference, but it does not.

PLEASE HELP! Thank you!
-Nick

Have you also tried type="StringClob" (and a big length)? If it doesn't work either, then please reopen the issue.

I modified the mapping to be:

<property name="LongStringVal" type="String">
<column name="LongStringVal" length="1000000" sql-type="StringClob" not-null="false"/>
</property>

and it is still truncating to exactly 4000 chars. I'm unfamiliar with opening or reopening issues. How should I do that?

Really though, I'm in trouble if I can't get it fixed sooner. Does anyone know where I might start looking in the source code to try and put in a hack?

Thank you,
-Nick

This worked for me:

Note the lack of the <column> tag, and that type="StringClob" is NOT sql-type="StringClob".

aarnott, you da man. if anyone tries to tell you different, you send them my way.

-Thanks