Limiting NVARCHAR size in SQLServer?

Asked 2009-05-28T11:16:25.867

I was wondering what would be the consequences of setting NVARCHAR fields to MAX instead of a specific size in SQL Server 2008, and limiting the input from the application's logic. Also, would these be a bad design practice?

sql-server nvarchar

Edit Report

1 Answer

NVARCHAR(MAX) is a lot better at performing with smaller data than the old NTEXT data type, however, NVARCHAR(n) will always be more efficient in some areas.

As a general rule, using the datatype that best represents the data you are storing is almost always the best practice.

answered 2009-05-28T11:27:04.177

Limiting NVARCHAR size in SQLServer?

1 Answer

Your Answer