RE: [PHP] MySQL vs. Postgresql

LONGBLOB has a max. size of 2^32 bytes, or a few Gb. > > On Wed, 11 Oct 2000, moshe doron wrote: > > mysql is great for images coz his blob type (check for the correct type) > > have no size limit like the psql. > > the actual size of the db is no matter till u tring to make a > search on the > > huge fields (doesnt make sense on images) > > > > -- > > > > moshe. > > You are misinformed my friend, the BLOB field has a Max size of 65k. > > >From the MySQL manual: > (http://www.mysql.com/documentation/mysql/commented/manual.php?sec > tion=Column_types) > BLOB > TEXT A BLOB or TEXT column with a maximum length of 65535 (2^16 - > 1) characters. > > Sorry :) > > -- > James Atkinson > ----------------------------------------------------------------- > James Atkinson 100world > Technical Developer 512-1529 West 6th Avenue > phone: +1-604-637-8122 Vancouver, BC, V6J 1R1 > fax: +1-604-742-1770 Canada > email: james.atkinson@100world.com http://www.100world.com > > +---------------------------------------------------------------+ > | This message may contain confidential and/or privileged | > | information. If you are not the addressee or authorized to | > | receive this for the addressee, you must not use, copy, | > | discolse or take any action based on this message or any | > | information herein. If you have received this message in | > | error, please advise the sender immediately by reply e-mail | > | and delete this message. Thank you for you cooperation | > +---------------------------------------------------------------+ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >