Varchar(MAX)

#1

Can someone tell me how much data can I store in a colume defined as
Varchar(max). I am using SQL 2008.

Thanks

#2

On Thu, 7 Oct 2010 17:33:19 -0400, Phil Hunt wrote:

Quote:

Can someone tell me how much data can I store in a colume defined as
Varchar(max). I am using SQL 2008.

Thanks

Hi Phil,

The maximum storage size for all ...(max) data type is 2^31-1 bytes. And
since varchar uses 1 byte for each character, that works out to 2^31-1
characters. Or, in decimal form, 2,147,483,647 characters.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

#3

Thanks. That's what I thought. But when I tried to store an huge xml (around
16 m) in the varchar(max), nothing is stored. And no error was raised, do
you know why ?

"Hugo Kornelis" <hugo (AT) perFact (DOT) REMOVETHIS.info.INVALID> wrote

Quote:

On Thu, 7 Oct 2010 17:33:19 -0400, Phil Hunt wrote:

Can someone tell me how much data can I store in a colume defined as
Varchar(max). I am using SQL 2008.

Thanks

Hi Phil,

The maximum storage size for all ...(max) data type is 2^31-1 bytes. And
since varchar uses 1 byte for each character, that works out to 2^31-1
characters. Or, in decimal form, 2,147,483,647 characters.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

#4

I got it. IT stored, the studio does not show it, stupid

"Phil Hunt" <aaa (AT) aaa (DOT) com> wrote

Quote:

Thanks. That's what I thought. But when I tried to store an huge xml
(around 16 m) in the varchar(max), nothing is stored. And no error was
raised, do you know why ?

"Hugo Kornelis" <hugo (AT) perFact (DOT) REMOVETHIS.info.INVALID> wrote in message
news:dpfta691do0diebmiste68up03gts9q1cp (AT) 4ax (DOT) com...
On Thu, 7 Oct 2010 17:33:19 -0400, Phil Hunt wrote:

Can someone tell me how much data can I store in a colume defined as
Varchar(max). I am using SQL 2008.

Thanks

Hi Phil,

The maximum storage size for all ...(max) data type is 2^31-1 bytes. And
since varchar uses 1 byte for each character, that works out to 2^31-1
characters. Or, in decimal form, 2,147,483,647 characters.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Varchar(MAX)

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Varchar(MAX) - 10-07-2010 , 04:33 PM

Re: Varchar(MAX) - 10-08-2010 , 01:51 AM

Re: Varchar(MAX) - 10-08-2010 , 09:37 AM

Re: Varchar(MAX) - 10-08-2010 , 03:30 PM