View previous topic :: View next topic
|
Author |
Message |
gangapd
New User
Joined: 04 Oct 2016 Posts: 2 Location: India
|
|
|
|
Hi All,
I was reading about LOBs here
In page 42, whey they talk about ROWID, they say
"The generated ROWID is externalized as a 44 byte value (40 bytes of data plus length fields), but stored as VARCHAR (17)"
I dint understand the part where 44byte value is stored in VARCHAR (17). VARCHAR (17) can store a maximum value of 17 bytes?
Please clarify |
|
Back to top |
|
|
Garry Carroll
Senior Member
Joined: 08 May 2006 Posts: 1193 Location: Dublin, Ireland
|
|
|
|
If you read the page carefully you will see that the first 14 bytes are what's stored. The last 8 bytes are generated at SELECT time. Both of these add to 22 bytes of hexadecimal values which, when externalised as printable, occupy 44 bytes. This accounts for VARCHAR(14)
In the last paragraph at the bottom of the page is stated that 3 bytes are left for future expansion of ROWIDs - this, added to the 14 bytes previously explained, accounts for the VARCHAR(17).
Garry. |
|
Back to top |
|
|
|