List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 27 2003 11:18pm
Subject:Re: SELECT HEX("abc") is broken...
View as plain text  
At 16:45 -0800 3/26/03, Daevid Vincent wrote:
>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
Thread
SELECT HEX("abc") is broken...Daevid Vincent28 Mar
  • Re: SELECT HEX("abc") is broken...Paul DuBois28 Mar
  • Re: SELECT HEX("abc") is broken...Fred van Engen28 Mar