Re: MySQL vs. Postgresql

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?section=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 | +---------------------------------------------------------------+