Bryan Porter wrote:
>
> If I want to store binary data (images, soundfiles, etc) inside the MySQL
> database, how do I get these files into the database? Is there a way to do
> this using the DBI/DBD interface with perl?
>
> Any help would be greatly appreciated!
>
> Regards,
> Bryan Porter
> Programmer/Analyst
>
> Executive Personal Computers, Inc.
> Ph: 209.1999
> Fx: 209.1998
>
You can use DBI->quote() to properly escape the funny characters. Also
make sure that you do not exceed max_packet_length in the query, and
somebody recently pointed out that thread_stack may also need to be big
enough to handle large insert statements.
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
