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. +------------+
Prior to MySQL 4.0.1, HEX() always interprets its argument as a string.
-- Paul DuBois http://www.kitebird.com/ sql, query
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
