---
name: "mysql_hex_string"
section: "3"
platform: "linux"
package: "mariadb"
version: "13.0.2-2"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/mysql_hex_string"
---

# mysql\_hex\_string(3)

### 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)](/mysql_real_escape_string/3.md)**