Inserting encrypted data into postgres

From: "K Old" <kevsurf4(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Inserting encrypted data into postgres
Date: 2001-10-03 20:05:06
Message-ID: F184yKFRJrzdDW6lCPx0000ef1f@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am trying to load encrypted data (a credit card number encrypted by the
Crypt::Twofish perl library) and postgres won't accept the data. I have
tried escaping each character, and nothing works.

For example a credit card number like

7384998737264839

when encrypted by Crypt::Twofish would look like

q.'

I cannot get postgres to accept this input. Any ideas of different
datatypes, or ways I can get it to accept this highly encrypted string?

I have several modules that encrypt the string with letters and numbers
rather than symbols, etc. like Twofish, but would love to have this solution
work.

Any help is appreciated.

Kevin
kevsurf4(at)hotmail(dot)com

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-10-03 20:45:52 Re: make problems on Apple's new 10.1 os
Previous Message Keary Suska 2001-10-03 18:47:05 Re: Sub-select testing group membership (Arrays)