(keitai-l) Re: keitai email address length

On Tuesday, August 5, 2003, at 02:59 PM, keitai-l_at_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)