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
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
>>
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Oct 03, 2001 at 03:06:49PM -0500, K Old wrote:
> 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 nothin
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
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