<div>
I'd use nvarchar(max).<br />
<br />
Lee
</div>


<div>
that would allow for 4000 characters correct?
</div>


that would allow for 4000 characters correct?

<div>
so if we set a maxlength of 5000 characters i the UI we will be safe, and we would not have any perfomance issues?
</div>


so if we set a maxlength of 5000 characters i the UI we will be safe, and we would not have any perfomance issues?

<div>
No, just set the column type to be nvarchar(max). You wouldn't be able to do nvarchar(5000) as this will exceed the row size limit.<br />
<br />
Lee
</div>


No, just set the column type to be nvarchar(max). You wouldn't be able to do nvarchar(5000) as this will exceed the row size limit.

Lee

<div>
ok, but i should still limit the UI to restrict the entry of more then 5000 charaters, right?
</div>


ok, but i should still limit the UI to restrict the entry of more then 5000 charaters, right?

<div>
Can we fit 10,000 characters wth nvachar(max)?
</div>


Can we fit 10,000 characters wth nvachar(max)?

<div>
yes, no problem. the &quot;max&quot; stands for 2GB of data, so 1 000 000 000 characters for Nvarchar
</div>


yes, no problem. the "max" stands for 2GB of data, so 1 000 000 000 characters for Nvarchar

<div>
<div class="content wysiwyg-content">
We are designing a table and we need a column to handle 2000 to 5000 characters. &nbsp;What is the best datatype for this column? &nbsp;ntext, nvarchar(2000), nvarchar(5000). &nbsp;We are using SQL 2005 and SQL 2008.
</div>
</div>


We are designing a table and we need a column to handle 2000 to 5000 characters.  What is the best datatype for this column?  ntext, nvarchar(2000), nvarchar(5000).  We are using SQL 2005 and SQL 2008.

SQL column  ntext, nvarchar

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.