mysql_hex_string - Man Page

Name

mysql_hex_string - create a hexadecimal string

Synopsis

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

Description

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').

Parameter

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

Notes

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

Return value

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

See also

• mysql_real_escape_string(3)