Hi Jay,
I stumbled on the same problem when using BINARY columns in SQL.
And we found it is a small bug in the code (it was only quoting the blob,
not escaping it).
See "SOLVED: SSQLS with BINARY column is only escaped when defined as "NOT
NULL"" in the mailing list of May 2011.
You only need a small patch in the current 3.1.0 code and recompile it:
Quote from Warren:
So you're saying the fix is this:
Index: lib/type_info.cpp
===================================================================
--- lib/type_info.cpp (revision 2689)
+++ lib/type_info.cpp (working copy)
@@ -252,7 +252,7 @@
bool mysql_type_info::escape_q() const
{
- const type_info& ti = c_type();
+ const type_info& ti = base_type().c_type();
return ti == typeid(string) ||
ti == typeid(sql_enum) ||
ti == typeid(sql_blob) ||
End Quote.
So basically change the line "const type_info& ti = ...."
Once you have this in place, everything works great !
----- Original Message -----
From: "Jay Sprenkle" <jsprenkle@stripped>
To: <plusplus@stripped>
Sent: Wednesday, July 13, 2011 11:40 PM
Subject: Re: update fails... any suggestions?
> My catch blocks weren't correct.
>
> It looks like an escaping error on the blob.
>
> Thanks for the help.
>
