Storage required for VARCHAR in V9.5

Question posted by: Mark A (Guest) on August 4th, 2008 07:35 PM

I was looking at the DB2 LUW V9.5 SQL Reference manual, and noticed that a
VARCHAR that is not nullable and with value compression not active, a
VARCHAR uses N+4 bytes of storage (N is the actual length of the data
stored). I thought it was N+2 in V8.

I am wrong that this has changed, and if not, what why is the extra two
bytes needed?

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

Jan M. Nelken

Guest

n/a Posts

August 4th, 2008
07:45 PM
#2

Re: Storage required for VARCHAR in V9.5

Mark A wrote:

Quote:

Originally Posted by

Length became an integer instead of smallint.

Jan M. Nelken

Mark A

Guest

n/a Posts

August 4th, 2008
08:55 PM
#3

Re: Storage required for VARCHAR in V9.5

"Jan M. Nelken" <Unknown.User@Invalid.Domainwrote in message
news:6fp4fcFc8elsU1@mid.individual.net...

Quote:

Originally Posted by

Length became an integer instead of smallint.
>
Jan M. Nelken

Why?

Not the answer you were looking for? Post your question . . .
182,266 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Didn't find the answer you were looking for?
Post Your Question

Top Community Contributors