mysql_real_escape_string

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <mysql.h>

MYSQL mysql;

int main (int argc, char **argv)
{

    unsigned long result;
    char prntStr[100]={0};

    /*
     {'\x00','\x1a','\n','\'','\"','\r'}
     HEX: {0x0,0x1A,0x0A,0x27,0x22,0x0D}
     DEC: {0,26,10,39,34,13}
     */

    char testStr[]={'\x00','\x1a','\n','\'','\"','\r'};
    int size = 6;

    if(!mysql_init(&mysql))
    {
        printf("Error initializing MySQL client\n");
        return 1;
    }


    result = mysql_real_escape_string(&mysql,prntStr,testStr,size);

    if(result == (unsigned long)-1){
        printf("an error occurs\n");
    }
    else{
        printf("output: %s result: %ld\n",prntStr, result);
    }

    mysql_close(&mysql);
    mysql_library_end();

    return 0;
}

/*
output: \0\Z\n\'\"\r result: 12
*/