#38403 [Opn->Bgs]: unable to quote \0 to sql strings
| From: | tony2001@php.net | Date: | Thu, 10 Aug 2006 16:53:45 +0000 |
| Subject: | #38403 [Opn->Bgs]: unable to quote \0 to sql strings | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-100659@lists.php.net to get a copy of this message | ||
ID: 38403
Updated by: tony2001@php.net
Reported By: neta at abcb dot it
-Status: Open
+Status: Bogus
Bug Type: PDO related
Operating System: OSX/NetBSD/FreeBSD
PHP Version: 5.1.4
New Comment:
Use PDO::quote() to quote binary data before inserting it to the DB.
Previous Comments:
------------------------------------------------------------------------
[2006-08-09 21:05:12] neta at abcb dot it
Description:
------------
Sending TEXT data to PostgreSQL a database, the string gets
truncated at the first occurrence of \0.
Reproduce code:
---------------
Just try to INSERT "abc\0def" into a TEXT field.
Expected result:
----------------
'abc'
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=38403&edit=1