X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 83FDB9FA502 for ; Thu, 20 Jul 2006 08:52:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 64168-08 for ; Thu, 20 Jul 2006 11:52:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtpgate3.pacific.net.sg (smtpgate3.pacific.net.sg [203.81.36.23]) by postgresql.org (Postfix) with SMTP id 1E0279FA4AE for ; Thu, 20 Jul 2006 08:52:34 -0300 (ADT) Received: (qmail 30885 invoked from network); 20 Jul 2006 11:52:31 -0000 Received: from ppp44.dyn73.pacific.net.sg (HELO ?127.0.0.1?) (debraneys@210.24.73.44) by smtpgate3.pacific.net.sg with (DHE-RSA-AES256-SHA encrypted) ESMTPA; 20 Jul 2006 11:52:28 -0000 Message-ID: <44BF6E78.9090207@debraneys.com> Date: Thu, 20 Jul 2006 19:52:24 +0800 From: John Tregea User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: Aaron Bono CC: Michael Fuhr , pgsql-sql@postgresql.org Subject: Re: Storing encrypted data? References: <44BAE3B0.8060403@debraneys.com> <20060717030705.GA87022@winnie.fuhr.org> <44BB28AC.3070302@debraneys.com> <44BDF054.5060603@debraneys.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/260 X-Sequence-Number: 25834 Hi Aaron, I removed them because when I bring the data back into my GUI, the returns are treated as a record break by the software and I cannot decrypt them or display the rest of the record that is not encrypted. Regards John T Aaron Bono wrote: > On 7/19/06, *John Tregea* > wrote: > > Hi Aaron, > > I found that your suggestion worked well. For some reason the IDE > I use > (Revolution) put a return character every 73rd character when it > did the > base64encode, but I strip those out and there no further problems. I > don't even have to put them back later to decode it. > > > > I usually leave the return characters where they are. > > I am curious, why did you decide to remove the return characters? > > ================================================================== > Aaron Bono > Aranya Software Technologies, Inc. > http://www.aranya.com > ==================================================================