| Subject | Varchars and the Network |
|---|---|
| Author | Paul Maliphant |
| Post date | 2001-08-21T22:36:41Z |
In an article at
http://community.borland.com/article/0,1410,27569,00.html
This is the technical paper from a talk given at the 12th Annual Borland Developer's Conference
By Robert Schieck MER Systems Inc.
There is the following statement re Varchars
"What most people don't realize is a InterBase passes chars and varchars over the network the same way, fully padded out. To help you visualize this, think of a varchar(32000) with just the letter 'a' in the field. When this field is
passed over the network it will be passed as the letter 'a' and 31,999 filler characters. "
Is this true ? I can understand this happening with CHAR fields, as the documentation explicitly states they are stored with padding.
cheers
Paul Maliphant
http://community.borland.com/article/0,1410,27569,00.html
This is the technical paper from a talk given at the 12th Annual Borland Developer's Conference
By Robert Schieck MER Systems Inc.
There is the following statement re Varchars
"What most people don't realize is a InterBase passes chars and varchars over the network the same way, fully padded out. To help you visualize this, think of a varchar(32000) with just the letter 'a' in the field. When this field is
passed over the network it will be passed as the letter 'a' and 31,999 filler characters. "
Is this true ? I can understand this happening with CHAR fields, as the documentation explicitly states they are stored with padding.
cheers
Paul Maliphant