Sunday, January 16, 2011

Why does varchar occupy 2 extra bytes?

Why does varchar occupy 2 extra bytes?
Answer

The two bytes are for the number of bytes for the binary length of the field.
It stores the exact no of characters stored in varchar

No comments:

Post a Comment