I don't know about Postgress, but you could convert the string to hex or uuencode it, then you have normal printable characters which should be acceptable, if a bit longer string.
K Old wrote: > 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 > [EMAIL PROTECTED] > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- James D. White ([EMAIL PROTECTED]) Department of Chemistry and Biochemistry University of Oklahoma 620 Parrington Oval, Room 313 Norman, OK 73019-3051 Phone: (405) 325-4912, FAX: (405) 325-7762
