On Tuesday, August 5, 2003, at 02:59 PM, keitai-l@appelsiini.net wrote:
> You are allocating the same amount of resources whether you specify
> varchar(255) or varchar(1).
I have tried quite hard to look for a way in which this could be
correct - and there isn't one...
try to ram a 255 char length string into a varchar(1) field and you use
2 bytes..
try to ram it into a varchar(255) string and you use quite a lot
more....
ram a 1 byte string into both, and it makes no difference, I grant...
But that is what you USED - not what you allocated...
Nick
(not that anyone would ever allocate varchar(1) field - a straight
char(1) would presumably take a byte less....)
This is all offtopic - so I shall respond offlist, if at all - to any
responses that are not about max keitai email lengths)
Received on Tue Aug 5 14:23:29 2003