MySQL Forums
Forum List  »  Knowledge Base

Encode() Decode()
Posted by: Steven Boon
Date: September 10, 2007 08:47AM

I am using Encode(password,'123456') to encrypt user password on my host server. In my home local machine, I am having a Mysql databse too which import all data from my host server. However, I found that the return value of decode(password,'123456') in my local machine is different with the return value of my host server. Why?

Is it mysql database version problem?

I am setting the password field as "varchar" type. Does this cause the problem?

When should I use Encode()? When should are use AES_encryppt? what is the different?

Options: ReplyQuote

Written By
Encode() Decode()
September 10, 2007 08:47AM

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.