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
