List:General Discussion« Previous MessageNext Message »
From:Jeff Smelser Date:February 4 2005 9:47pm
Subject:Re: ENCODE & DECODE
View as plain text  
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.

Jeff

Attachment: [application/pgp-signature]
Thread
ENCODE & DECODEshaun thornburgh4 Feb
  • Re: ENCODE & DECODEJeff Smelser4 Feb
    • Re: ENCODE & DECODEshaun thornburgh4 Feb
      • Re: ENCODE & DECODEGleb Paharenko4 Feb
      • Re: ENCODE & DECODEJeff Smelser4 Feb
RE: ENCODE & DECODEJohn Trammell4 Feb
  • Re: ENCODE & DECODEJeff Smelser4 Feb