in reply to Please Help: encryption of column before uploading to DB

Depends on how much security is required. Please search this site and the Internet for various implementations.

Here is a simple (but insecure) one - replace both your encrypt and decrypt functions with this:

sub rot13 { my $text = shift; $text = tr/A-Za-z/N-ZA-Mn-za-m/; return $text; }

             "I'm fairly sure if they took porn off the Internet, there'd only be one website left, and it'd be called 'Bring Back the Porn!'"
        -- Dr. Cox, Scrubs

Replies are listed 'Best First'.
Re^2: Please Help: encryption of column before uploading to DB
by david_lyon (Sexton) on Apr 30, 2013 at 18:42 UTC
    Thanks for your efforts...useful and helped