From: Jeff Smelser
Date: February 4 2005 9:47pm
Subject: Re: ENCODE & DECODE
List-Archive: http://lists.mysql.com/mysql/179474
Message-Id: <200502041547.29187.tradergt@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed;
  boundary="nextPart5278314.1avGFGTtmn";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart5278314.1avGFGTtmn
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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.. =20

I am not sure what version he is using, but that should have worked.

Jeff

--nextPart5278314.1avGFGTtmn
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQBCA+1xoOk9EvUvEtgRAlTqAJ9I+1t3E/JLszK6xTRuIzC0jSNuxwCffhMY
Mko85qnR1U5mZKBf1RDc+iI=
=fpg7
-----END PGP SIGNATURE-----

--nextPart5278314.1avGFGTtmn--