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
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
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