From: Warren Young
Date: May 6 2011 12:34pm
Subject: Re: SSQLS with BINARY column is sometimes not escaped
List-Archive: http://lists.mysql.com/plusplus/9341
Message-Id: <4DC3EAC5.8040000@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 5/5/2011 2:33 PM, Kemet wrote:
> am I doing something wrong ?

For one, a lot of people will have tl;dr'd on this post.

You'll get more and better answers if you can distill your problems 
better.  Ideally, you want to provide people a patch to one of the 
MySQL++ examples that demonstrates the problem, so they can just try it 
on their system and see what you're seeing.

> q.storein(vChain);

[snip]

> This call to GetBlockHeightFromHash with vChain[iChain].prevhash works
> incorrectly: it only gets quoted, NO ESCAPING is done :(

Why do you expect results from the database to be escaped in your 
program's view of the returned data?  I don't know what the MySQL IPC 
protocol looks like; there may be some escaping in it, but that's an 
implementation detail below even MySQL++.  By the time the returned data 
get transformed into SSQLSes, any such escaping is removed.

The only escaping you should be worrying about is that used to send data 
*to* the DBMS, and MySQL++ does some escaping for you already.