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 the ASCII alphabet by 13 places. i.e. A
becomes N, B becomes O, C becomes P, etc. The set wraps so that N becomes
A, O becomes B, etc. It's nice because the encrypt and decrypt functions
are exactly the same.
Rene
At 11:29 AM 8/14/01, you 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.
>
>Regards,
>Michael
--
René Churchill [EMAIL PROTECTED]
Vermont Web Wizard, LLC 802-244-5151
Specializing in Web Programming 802-244-5512 (fax)
http://www.vtwebwizard.com
---------------------------------------------------------------------
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
