On Mon, 2009-01-05 at 19:15 +0000, Stuart wrote: > 2009/1/5 Frank Stanovcak <blindspot...@comcast.net>: > > It's been a while since I've programed (VB was on version 4) I was wondering > > if any one could tell me what the diff is between char, varchar, and text in > > mysql. > > I know this isn't a mysql news group, but since I am using php for the > > interaction it seemed like the place to ask. Thanks in advance, and have a > > great day! > > char: the space required for the length of the field is allocated for > each row no matter how much of it is used. > > varchar: only the space required for the content of the field is > allocated per row but these fields are limited to 255 chars (IIRC) in > length. > > text: for all intents and purposes these have unlimited length (4GBish IIRC). > > There is a page in the MySQL manual that explains all of the data > formats. Google for mysql data formats and you'll likely get it.
It's generally worth mentioning that you can usually index char or varchar, but not text. Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
