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: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
