[FSUG-Bangalore] how to insert mp3 or audio files into mysql database

[Amit Saha]

On Tue, Mar 9, 2010 at 10:25 AM, Anurag <anurag at gnuer.org> wrote:
> 2010/3/9 rajkumar vbalakrishnasamy <rajkumar.lynx at 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 at mm.gnu.org.in
> http://mm.gnu.org.in/cgi-bin/mailman/listinfo/fsug-bangalore
>



-- 
Journal: http://amitksaha.wordpress.com,
µ-blog: http://twitter.com/amitsaha

Freenode: cornucopic in #scheme, #lisp, #math,#linux, #python