MySQL Forums
Forum List  »  Newbie

des_decrypt and des_encrypt question
Posted by: shamsingh
Date: May 01, 2005 01:10AM

Whye would the following return NULL:

select des_decrypt(des_encrypt('sample','mykey1'),'mykey1');


Whenever I try just inserting into a BLOB using des_encrypt I also get a NULL when
selecting the column using des_decrypt . Do I need to enable encryption when starting mysql or something?
The examples in the docs seem pretty straight forward and I copied them character for character.

Thanks for you help.

Options: ReplyQuote


Subject
Written By
Posted
des_decrypt and des_encrypt question
May 01, 2005 01:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.