Re: Because you guys/gals/girls/women/insert pc term here are a smart lot

On Mon, 2009-01-05 at 19:15 +0000, Stuart wrote: > 2009/1/5 Frank Stanovcak <blindspotpro@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