Hi all, I am using mysql database for my ivrs project and i am using jsp to insert data into mysql database and now i can insert and retrive image into the database using blob datatype but i cannot insert mp3 into blob datatype column its says error "Packet size exceeds".
2010/3/9 rajkumar vbalakrishnasamy rajkumar.lynx@gmail.com:
Hi all, I am using mysql database for my ivrs project and i am using jsp to insert data into mysql database and now i can insert and retrive image into the database using blob datatype but i cannot insert mp3 into blob datatype column its says error "Packet size exceeds".
Wouldn't it be better to save the mp3 file on the filesystem, and just store its path in the DB?
Anurag
On Tue, Mar 9, 2010 at 10:25 AM, Anurag anurag@gnuer.org wrote:
2010/3/9 rajkumar vbalakrishnasamy rajkumar.lynx@gmail.com:
Hi all, I am using mysql database for my ivrs project and i am using jsp to insert data into mysql database and now i can insert and retrive image into the database using blob datatype but i cannot insert mp3 into blob datatype column its says error "Packet size exceeds".
Wouldn't it be better to save the mp3 file on the filesystem, and just store its path in the DB?
Or, if at all you need to store in in the database, look up BLOB data type.
Best, Amit
Anurag
http://web.gnuer.org/ _______________________________________________ FSUG-Bangalore mailing list FSUG-Bangalore@mm.gnu.org.in http://mm.gnu.org.in/cgi-bin/mailman/listinfo/fsug-bangalore