mysql_hex_string

mysql_hex_string converts a binary buffer to a hex-encoded string for safe embedding in SQL; the output buffer must be at least 2*length+1 bytes.

Syntax

unsigned long mysql_hex_string(char * to,
                               const char * from,
                               unsigned long len);

Parameters

• to - result buffer

• from - the string which will be encoded

• len - length of the string (from)

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

Return Value

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

• The size of the buffer for the encoded string must be 2 * length + 1.

• The encoded string does not contain a leading X'.

See Also

• mysql_real_escape_string()

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}