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
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 [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Postgres and gzcompress
Date: Wed, 06 Sep 2006 15:39:37 -0700
Hi,
I would like
Hello all,
I need to create a script that can open a connection to a given .mdb file
(Microsoft Access) and do some light selects on it, anyway ...
The problem that i wont create an ODBC instance, i wont and cant install
ODBC support on the server for the unique purpose of doing that on the mdb
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 =