Hello DBI folks!
If I have a column that is binary and data that is binary do I simply
$dbh->quote() it on an insert?
IE
my $binary_content = get_binary_stuff();
my $binary_content_Q = $dbh->quote($binary_content);
$dbh->do("UPDATE MyStuff SET BinaryGoodies=$binary_content_Q WHERE ID=1");
...
Or do I need to convert it to hex and then $dbh->quote() the hex
version (or not quote it)?
If I do need to make it hex first do I need to "unhex" it, after I
SELECT it into a variable, to get it into the original binary format?
(w/ pack()/unpack()??? which is a bit OT for this list...)
TIA
Lee.M - JupiterHost.Net
- Re: using binary data in variable in an INSERT/UPDATE s... JupiterHost.Net
- Re: using binary data in variable in an INSERT/UPD... JupiterHost.Net
- Re: using binary data in variable in an INSERT... JupiterHost.Net
- RE: using binary data in variable in an INSERT... Andy Hassall
- Re: using binary data in variable in an IN... JupiterHost.Net
- Re: using binary data in variable in an INSERT... Scott T. Hildreth
- Re: using binary data in variable in an INSERT... Scott T. Hildreth
