O'Reilly logo

Teradata Database Administration – Teradata Internals by Tom Coffing, Todd Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6 - Data Stored in the Row

“I went to a general store but they wouldn't let me buy anything specific.”

- Steven Wright

 

The Varchar Offset

images

If your table has Varchar, Varbyte, Vargraphic, Blob or Clob column, then there will be at least two Varchar offset columns of two bytes. The Varchar Offset shows the byte location in the row where the Varchar field starts. There will be a Varchar Offset for each Varchar column you have. The reason I mentioned that if you have one Varchar column you will have at least two Varchar Offsets is because the last Varchar Offset is where the last Varchar column ends.

 

An Example of a Varchar Offset

There ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required