ID: 14013
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Closed
Bug Type: OCI8 related
Operating System: Linux 2.2, Solaris 2.6
PHP Version: 4.0.6
New Comment:
try storing in a varchar2 firld, if you use CHAR oracle will trim
traing spaces.
Previous Comments:
------------------------------------------------------------------------
[2001-11-11 06:49:19] [EMAIL PROTECTED]
Erm, yeah, that's supposed to be '$id = 666;'.
------------------------------------------------------------------------
[2001-11-11 03:28:34] [EMAIL PROTECTED]
When inserting text using named binds, PHP will strip trailing spaces.
The same query on the same database using the same Oracle client
libraries. (All Oracle 8.1.6)
$db = ocilogon("u", "p", "sid");
$st = ociparse($db, "insert into test values (:id, :text)");
ocibindbyname($st, ":text", &$text, 2000);
ocibindbyname($st, ":id", &$id, 22);
$text = " this line has spaces ";
$node_id = 666;
ociexecute($st);
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=14013&edit=1
