Hi!
There is a workaround for it using ENCODE and DECODE functions.
Insert data in this style:
INSERT INTO t VALUES (field) ENCODE('string','password');
Retrive it using decode():
SELECT decode (field,'password') FROM t;
Perhaps this helps.
Tobias Bengtsson wrote:
> Hi!
>
> I want to store my mysqldatabase encrypted on disk, it contains sensitive
> data. Is there anybody out there doing this already? Or do I have to rewrite
> the myisam routines? Or is there another way?
>
> Regards, Tobbe
>
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Barkov <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia
<___/ www.mysql.com +7-902-856-80-21
---------------------------------------------------------------------
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