http://www.mysql.com/doc/en/String_functions.html
Your MySQL connection id is 14 to server version: 3.23.56-Max
mysql> SELECT HEX("abc");
+------------+
| HEX("abc") |
+------------+
| 0 | <<---- this should return 616263 according to the docs.
+------------+
mysql> SELECT HEX(255);
+----------+
| HEX(255) |
+----------+
| FF |
+----------+
mysql> SELECT 0x616263;
+----------+
| 0x616263 |
+----------+
| abc |
+----------+
"Ezekiel 25:17. The path of the righteous man is beset on all sides by the
inequities of the selfish and the tyranny of evil men. Blessed is he who in
the name of charity and goodwill shepherds the weak through the valley of
darkness, for he is TRULY his brother's keeper and the finder of lost
children. And I will strike down upon thee with GREAT vengeance and
FU-U-U-URIOUS anger, those who attempt to poison, and destroy my brothers!
And you will KNOW my name is the Lord, when I lay my vengeance upon thee!"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
