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

Thank you. I have a stupid/nasty habit of realizing I can search after I post a question. Problem was I was overwhelmed on google. I was hoping for a simple this type is good for this use because, but bad for other things because. type answer. My mantra around this office is "I'm old not addled damnit!" :) "Stuart" <stuttle@gmail.com> wrote in message news:a5f019de0901051115ree20159tbbcf5b3cb26337f8@mail.gmail.com... > 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. > > -Stuart > > -- > http://stut.net/