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
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
We upload jpegs using bind parameters into mysql using the following:
$stmt=replace into mytable (fld1,bfld1) values ('fld1',?);
$sth=$dbh-prepare($stmt);
$sth-execute($var_with_binary_data);
James D. White wrote:
7384998737264839
when encrypted by Crypt::Twofish would look like
You must use bytea type on postgres side to insert binary data, and bind
your variable as SQL_BINARY.
ALternatively, byte64 or hex encode your binary data.
On Wed, 3 Oct 2001, K Old wrote:
Hello,
I am trying to load encrypted data (a credit card number encrypted by the
Crypt::Twofish