Ansistring type length limit

Nightmare · **Joined:** Tue Feb 21, 2006 6:46 am **Posts:** 7

I have a table with column type nvarchar(6144) - but when I've created mapping for it - I've an exception:

Code:

System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 3 ("@p0"): Data type 0xE7 has an invalid data length or metadata length..

I've made some tests and now I see that the limit of string length equals to 4000 chars....Why?? And how to solve this?

michal · **Posted:** Wed Mar 29, 2006 10:19 am

This is a Sql Server limitation - maxmimum row size is 8000 bytes , that gives (theoretically) maximum nvarchar length is 4000 characters (2 bytes/unicode character)

For bigger strings use ntext SqlType and StringClob NHibernate type, the only problem with this is limited "select distinct" capability