Re: Because you guys/gals/girls/women/insert pc term here are a smart lot
| From: | Nathan Rixham | Date: | Tue, 06 Jan 2009 10:41:30 +0000 |
| Subject: | Re: Because you guys/gals/girls/women/insert pc term here are a smart lot | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-285502@lists.php.net to get a copy of this message | ||
Richard Heyes wrote:
storage size richard, as if you use char(100) then a string(4) will still use the space of string(100); whereas with varchar(100) it's only take up it's real space of string(4). it' may seem like a small amount of space but when you have 8 char(255) columns in a table with 10 million rows you'd noticed the difference considerably.So where's the advantage of VARCHAR ?Also I could be missing something, but I can't see the advantage in VARCHAR since space is not really a concern these days.char is fixed length and padded. If you don't fill up the space, the db does it for you (even though it seems it's internal only). http://dev.mysql.com/doc/refman/5.0/en/char.html When CHAR values are stored, they are right-padded with spaces to the specified length. When CHAR values are retrieved, trailing spaces are removed.