List:General Discussion« Previous MessageNext Message »
From:Fred van Engen Date:March 27 2003 11:57pm
Subject:Re: SELECT HEX("abc") is broken...
View as plain text  
On Wed, Mar 26, 2003 at 04:45:01PM -0800, 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.
> +------------+ 
> 

From http://www.mysql.com/doc/en/News-4.0.1.html :

- HEX(string) now returns the characters in string converted to hexadecimal.


I guess this is new functionality in 4.0.x and it was never added to
3.23.x. Be careful with the online manual, because it is for the latest
version of MySQL.


Regards,

Fred.

-- 
Fred van Engen                              XB Networks B.V.
email: fred.van.engen@stripped                Televisieweg 2
tel: +31 36 5462400                         1322 AC  Almere
fax: +31 36 5462424                         The Netherlands
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