I have a table that needs to store a small amount of binary data
The code needs to update a number of rows so I am building a "insert
into... on duplicate key update" string with multiple rows to be
inserted/updated. The binary data is escaped using conn::escape_string()
and delimited with single quotes.
This works well for most patterns including binary data containing zero
The problem - if the binary data contains the data "%1" it triggers a
"Not enough parameters to fill the template" exception.
Is there a trick to avoid mysql++ from treating %1 as a parameter
PS - using mysql++ 3.0.8.