The sql_hex()
function returns a numeric value for a hexadecimal expression, transforming 09af
into 0x09af
(for MySQL and SQLite). This is principally used to write hexadecimal content into a numerically-typed SQL column.
It accepts 3 parameters:
-
$val
is the character string to be translated, -
$serveur
, -
$option
.
Usage:
$hex = sql_hex('0123456789abcdef');
sql_updateq('table', array('column'=>$hex), 'id_table=' . $id_table);