mysql_hex_string - mariadb-corporation/mariadb-connector-c GitHub Wiki

mysql_hex_string - create a hexadecimal string

#include <mysql.h>
unsigned long mysql_hex_string(char * to,
                               const char * from,
                               unsigned long len);

This function is used to create a hexadecimal string which can be used in SQL statements. e.g. INSERT INTO my_blob VALUES(X'A0E1CD').

• to - result buffer
• from - the string which will be encoded
• len - length of the string (from)

• The size of the buffer for the encoded string must be 2 * length + 1.
• The encoded string does not contain a leading X'.

Returns the length of the encoded string without the trailing null character.

• mysql_real_escape_string()