List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 25 2001 4:24pm
Subject:Re: could not insert BLOB data type in a table
View as plain text  
At 5:23 PM +0400 7/25/01, Ilya Martynov wrote:
>PD> At 10:43 AM +0530 7/25/01, mysql@stripped wrote:
>>>  Hi,
>>>
>>>  I just want to know how to insert a BLOB data type in a field of a
>>>  table. I want to put the binary data stream not the file link in the
>>>  filed. The language i m using is PERL5.
>
>PD> Use $dbh->quote() or placeholders to insert the BLOB value into
>PD> the query string.  See the DBI docs.
>
>Only use placeholders. $dbh->quote() is unreliable (and this fact is
>documented in DBI documentation).

Please show me the part of the documentation that you're referring to,
and please supply a counter-example.  quote() is extremely useful for
producing SQL statements that will be executed by another program, a
situation for which placeholders are useless.

>
>--
>  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>| Ilya Martynov (http://martynov.org/)                                    |
>| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80  E4AE BE1A 53EB 323B DEE6 |
>| AGAVA Software Company (http://www.agava.com/)                          |
>  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


-- 
Paul DuBois, paul@stripped
Thread
could not insert BLOB data type in a tablemysql25 Jul
  • Re: could not insert BLOB data type in a tablePaul DuBois25 Jul
    • Re: could not insert BLOB data type in a tableIlya Martynov25 Jul
      • Re: could not insert BLOB data type in a tablePaul DuBois25 Jul
        • Re: could not insert BLOB data type in a tableIlya Martynov25 Jul