#36217 [Bgs->Csd]: with postgres 8.1, pg_escape_bytea escapes ' as '' and unescape leaves them ''
| From: | dabicho2001 at yahoo dot com dot mx | Date: | Mon, 30 Jan 2006 22:54:38 +0000 |
| Subject: | #36217 [Bgs->Csd]: with postgres 8.1, pg_escape_bytea escapes ' as '' and unescape leaves them '' | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-92666@lists.php.net to get a copy of this message | ||
ID: 36217
User updated by: dabicho2001 at yahoo dot com dot mx
Reported By: dabicho2001 at yahoo dot com dot mx
-Status: Bogus
+Status: Closed
Bug Type: PostgreSQL related
Operating System: linux
PHP Version: 4.4.2
New Comment:
silly me.
not a bug, just missinterpretation on my part.
Previous Comments:
------------------------------------------------------------------------
[2006-01-30 21:48:14] tony2001@php.net
pg_escape_bytea() is just a wrapper for PQescapeBytea() function from
Postgresql.
If you think it doesn't work properly - please report it to PG
developers.
------------------------------------------------------------------------
[2006-01-30 21:30:51] dabicho2001 at yahoo dot com dot mx
Description:
------------
pg_escape_bytea will escape a single quote as ''
i.e.
$a = "'";
$a = pg_escape_bytea($a);
$a now contains "''"
pg_unescape_bytea will leave them unmodified.
i.a.
$a = pg_unescape_bytea($a);
$a still contains "''"
apache's mod_php is 4.4.0
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36217&edit=1