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
Subject
Written By
Posted
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.