Subject | Space usage with TCP/IP & Varchars |
---|---|
Author | Jason Chapman |
Post date | 2000-06-19T10:26:20Z |
All,
It would appear that when data in VARCHAR's are returned over the network
that they are fixed width, is this true?
I.e. If I have a VARCHAR(1024) in a table with 'ABC' in one of the rows then
the TCP/IP packet contains ABC and a whole load of nil's.
I've posted this here as I believe it to be true (i.e. not support) and if
it is, then it represents a major network traffic problem.
Is it true? Am I missing something?
JAC.
It would appear that when data in VARCHAR's are returned over the network
that they are fixed width, is this true?
I.e. If I have a VARCHAR(1024) in a table with 'ABC' in one of the rows then
the TCP/IP packet contains ABC and a whole load of nil's.
I've posted this here as I believe it to be true (i.e. not support) and if
it is, then it represents a major network traffic problem.
Is it true? Am I missing something?
JAC.