Re: encrypt/decrypt question

2001-08-14 Thread Michael T. Babcock
>>I am very new to the encrypt and decrypt data process and would like to know how do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it at the later time. Grab a copy of mcrypt (search http://freshmeat.net/ for it) and read the docs for it -- its a good idea t

Re: encrypt/decrypt question

2001-08-14 Thread Michael Tam
14, 2001 12:16 PM Subject: Re: encrypt/decrypt question Michael, I just did something like this, and used the ENCODE/DECODE. Works well. Basically you want to assign a "special key" for the encoding/decoding of the data you want to encode/decode. The column type should be either a BLO

Re: encrypt/decrypt question

2001-08-14 Thread Rene Churchill
If all you're looking for is a trivial hiding of the data, then I'd suggest doing a rot13 on the string. I highly doubt there is a native SQL function that does this, so you'll need to write your own function in whatever interface you're using. Perl/PHP/whatever. Rot13 is a simple rotation of

Re: encrypt/decrypt question

2001-08-14 Thread mickalo
Michael, I just did something like this, and used the ENCODE/DECODE. Works well. Basically you want to assign a "special key" for the encoding/decoding of the data you want to encode/decode. The column type should be either a BLOB or TINYBOLD, as it's stored in a binary format, depend on the siz

encrypt/decrypt question

2001-08-14 Thread Michael Tam
Hi all, I am very new to the encrypt and decrypt data process and would like to know how do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it at the later time. I understood it sorts of contradict the point of security but I just want to use it to cove