On Aug 14, 2006, at 3:07 PM, Michael Babcock wrote:
Why would someone do a varchar(1).....it's no different in terms of
space-saving optimization that char(1), right? Just found this to
be odd.
I guess if it's empty, you save a whole byte...
Most likely, though, the table was created by a tool that defined
all character fields as varchar. In MySQL ISAM tables, if the varchar
field is 3 bytes or less, it creates it as a char anyway.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
