SQL Server Field with 8000 characters -- text or nvarchar?
- by twpc
I am adding a field to a SQL Server 2008 database. The field needs to accomodate up to 8000 characters (occasionally Unicode chars as well). Seems from my research that text data type is being deprecated. Go with nvarchar or stick with text anyway for such a large field?