Home / server / Questions / 272882
Accepted
user76678
Asked: 2011-05-24 11:48:40 +0800 CST

MS-SQL Server 2008 size limitation on data

  • 772

I recently discovered that MS-SQL Server 2008 imposes an upper limit of 8000 bytes for a column (for character data).
I need to store data that occusionally could surpass this limit.
Is there a way to do this?
The data are character strings.

Thanks

windows sql-server sql-server-2008 sql-server-2008-r2

1 Answers

  1. Best Answer

    Use varchar(max) or nvarchar(max). These have a storage limit of 2^31-1 bytes.

    • 2