Re: [OpenSER-Users] RE: [Users] unixodbc: use_escape_common

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.