On Friday 04 February 2005 03:31 pm, John Trammell wrote:
> In my version of MySQL (4.1.9), your sample code generates an error:
> mysql> select decode(encode("foo"));
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near '))' at line 1
your right, i was mistaken.. I use:
select des_decrypt(des_encrypt("foo")); which works fine..
I am not sure what version he is using, but that should have worked.