Hi, On Mon, Sep 20, 2010 at 4:59 AM, Tompkins Neil <neil.tompk...@googlemail.com> wrote: > Any ideas why my statement like SELECT SHA1('abc') AS my_sha is being > returned as binary value, I thought it should be returning HEX in anycase ?
Maybe because that's what it's intended to do. http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_sha1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org