21 Jun
2007
21 Jun
'07
3:55 p.m.
Hi all,
Just a note to say that from what I see in this source code, this would
also work with MS SQL Server (doubling single quotes instead of using
backslashes as escape).
Cheers,
Jerome
On Thu, 2007-06-21 at 14:31 +0300, Papadopoulos Georgios wrote:
Hello Henning
I just needed something quick and dirty so I just added the following
function and used it instead of escape_common. This works fine with
Oracle.
int sql_escape(char *dst, char *src, int src_len)
{
int i, j;
if(dst==0 || src==0 || src_len<=0)
return 0;
j = 0;
for(i=0; i<src_len; i++)
{
switch(src[i])
{
case '\'':
dst[j++] = '\'';
dst[j++] = src[i];
break;
default:
dst[j++] = src[i];
}
}
return j;
}
It would be nice to add this as a configuration parameter in the future.