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
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