Thank you for all your valuable help and input. I now got some idea to do
the job. Greatly appreciated.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Michael Tam" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, August 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 BLOB or
TINYBOLD, as it's stored in a binary format, depend on the size of the data
being encoded.
To encode the data, you do something like this.
The $key would equal a special value to encode then decode it back, without
the
$key, it will not be able to decode the encoded data. Like a password to
encode/decode.
INSERT INTO table_name VALUE
('foo','bar','foobar',ENCODE("$data_to_encode","$key"),'other_data');
Then to retrieve the encoded data,
SELECT DECODE(col_name_with_encode_data,"$key") FROM table_name WHERE
something
= 'A_Value';
This is a very simplistic example, but should give you some ideas on how it
can
work.
Hope this helps,
>>On Tue, 14 Aug 2001 11:29:07 -0700, "Michael Tam"
<[EMAIL PROTECTED]> wrote:
>>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 cover the data such that the non-technical user can see
the data is there but they couldn't understand them by just reading it.
>>
>> It may be a dump question but I would be greatly appreciated for any
suggestion or help.
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php