Re: SHA1 returns binary value

2010-09-20 Thread Paul DuBois
On Sep 17, 2010, at 7:08 AM, Tompkins Neil wrote: > Hi > > Why when I run the command (MySQL 5.1) SELECT SHA1('abc'); is it returned as > a binary value and not a string value ? If you mean, why is it a binary rather than a nonbinary (character) string, that's true of most of the encryption or

Re: SHA1 returns binary value

2010-09-17 Thread Aveek Misra
Use UNHEX(SHA1('abc')) to get the string value On Sep 17, 2010, at 5:38 PM, Tompkins Neil wrote: > Hi > > Why when I run the command (MySQL 5.1) SELECT SHA1('abc'); is it returned as > a binary value and not a string value ? > > Cheers > Neil -- MySQL General Mailing List For list archives: h