From: Ed Carp Date: March 13 1999 4:36pm Subject: Re: [spam 03.02/10.00 -pobox] Crypt Limitation? List-Archive: http://lists.mysql.com/mysql/168 Message-Id: <006501be6d6f$ee3068e0$74c9a8c0@traveler.airmail.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit >I've been using the CRYPT function, but it seems I can >only encrypt strings of eight characters or less, since longer >strings with the same first eight characters >will return the same encrypted string even if they are >different strings. Is there a way to encrypt longer >strings? I've read the docs, and didn't see anything >about this limitation. At the risk of sounding like I just graduated from high school, crypt sucks for any sort of serious encryption. What are you encrypting? If a one-way hash is all you need, why not use md5?