MySQL Forums
Forum List  »  Newbie

Re: using BLOB in MySQL
Posted by: Kai Voigt
Date: July 12, 2005 09:02PM

MySQL supports different BLOB sizes. BLOB can take up to 64KByte, MEDIUMBLOB up to 16 MByte and LONGBLOB up to 4 GByte. So pick whatever fits best for you.

I don't know of any out-of-the-box application to store images in a MySQL database, but you can use any programming language that supports MySQL to create such an application yourself. MySQL provides commands to load binary data into tables and to retrieve them later.

Read http://dev.mysql.com/doc/mysql/en/string-functions.html for the load_file() function.

More about BLOB types: http://dev.mysql.com/doc/mysql/en/blob.html

--
Kai Voigt, Senior Instructor, MySQL AB
kai@mysql.com, www.mysql.com
Office: Kiel, Germany

Options: ReplyQuote


Subject
Written By
Posted
July 12, 2005 11:11AM
Re: using BLOB in MySQL
July 12, 2005 09:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.