Monday, March 26, 2012

Max character in field

In a SQL Server Db, what is the maximum amount of data a field can hold?

I am using right now nvarchar with a length of 4000.

Is there another setting to allow even more in a field?

Thanks all,

ZathA VARCHAR can hold up to 8000 characters in SQL 2000. If you need more, look at the TEXT type.

No comments:

Post a Comment