Re: SELECT HEX("abc") is broken...

[Paul DuBois]

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