|The stupid question is the question not asked|
Inserting binary data into MySQLby markolus (Initiate)
|on Sep 17, 2003 at 00:09 UTC||Need Help??|
markolus has asked for the wisdom of the Perl Monks concerning the following question:
I am looking for some venerable guidance. My task, which has been well thought out(!), is to insert binary data into MySQL using Perl, naturally.
I wish to divide up any binary files into 1MB chunks and insert that into a LONGBLOB field in MySQL.
1) My question(s) is/are which Perl module will help me best to take a binary file and divide it up appropriately... and then at a later specified time re-assemble it back into its original format.
2) Also when inserting the chunks into MySQL what processing do I need to do on the file to make sure it goes in okay, a sort of Perl equivalent of the php addslashes function I suppose?
Thanks if you can spare the time to answer my question.