Hi Bastien,
Thanks a lot for your help. I finally got it to work by encoding after
doing the compress -- instead of before as you suggested.
So, using a text column type:
$dataToInsert = pg_escape_string(base64_encode(gzcompress($data)));
// insert here...
// select here...
$data = base64_decode(gzuncompress($row[0]));
- Nate
----Original Message Follows----
From: "Bastien Koert" <bastien_k@xxxxxxxxxxx>
To: natediggity97@xxxxxxxxxxx, php-db@xxxxxxxxxxxxx
Subject: RE: Postgres and gzcompress
Date: Wed, 06 Sep 2006 19:50:42 -0400
Try base_64_encod(ing) it then compressing it. on the way out, uncompress,
base-64-decode the value and see what you get
Bastien
From: "Nathan Harmon" <natediggity97@xxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Postgres and gzcompress
Date: Wed, 06 Sep 2006 15:39:37 -0700
Hi,
I would like to store a compressed string (XML) in my PostgreSQL table. So
far, I have been unsuccessful in uncompressing the data that I insert.
For example:
echo gzuncompress(gzcompress('this is a test'));
works fine.
But when i store the gzcompressed data in the table, the data that is
returned from a SELECT call does not match and the call to gzuncompress
throws a "data error" warning. I have tried storing in both text and bytea
column types.
The problem appears to be in the escaping. For example, with bytea:
$data = gzcompress('this is a test');
echo $data;
$data2 = pg_unescape_bytea(pg_escape_bytea($data));
echo $data2;
$data does not equal $data2.
And with a 'text' column type, i use pg_escape_string() and the returned
column value does not match.
Am i doing something wrong? Is there an easier way?
Thanks,
Nate
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
