Re: [PHP] Because you guys/gals/girls/women/insert pc term hereare a smart lot
This would be the winning answer. I've been using text up till now. I'll have to change that. Thank you! "Robert Cummings" wrote in message news:1231185251.4.2.ca...@localhost... > On Mon, 2009-01-05 at 19:15 +, Stuart wrote: >> 2009/1/5 Frank Stanovcak : >> > 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
Re: [PHP] Because you guys/gals/girls/women/insert pc term hereare a smart lot
Robert Cummings wrote: On Thu, 2009-01-08 at 10:51 +, Richard Heyes wrote: until you have to dump it, zip it, ssh it over to another box and then import it back in That's what fag breaks are for... :-) Well, that and smoking. So... when you're forgetful... have you ever had to bum a fag? yup, and had my fags bummed, but never my bum fagged - thank god -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Because you guys/gals/girls/women/insert pc term hereare a smart lot
And people tell me that I'm just wrong. "Nathan Rixham" wrote in message news:4965dffc.6020...@gmail.com... > Robert Cummings wrote: >> On Thu, 2009-01-08 at 10:51 +, Richard Heyes wrote: until you have to dump it, zip it, ssh it over to another box and then import it back in >>> That's what fag breaks are for... :-) Well, that and smoking. >> >> So... when you're forgetful... have you ever had to bum a fag? >> > > yup, and had my fags bummed, but never my bum fagged - thank god -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Because you guys/gals/girls/women/insert pc term hereare a smart lot
At 11:23 AM -0500 1/8/09, Frank Stanovcak wrote: And people tell me that I'm just wrong. Nothing new there. :-) Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php