#14013 [Com]: ocibindbyname strips trailing spaces
| From: | jens dot reibiger at rp dot vaw dot com | Date: | Fri, 31 Jan 2003 15:36:04 +0000 |
| Subject: | #14013 [Com]: ocibindbyname strips trailing spaces | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-31767@lists.php.net to get a copy of this message | ||
ID: 14013
Comment by: jens.reibiger@rp.vaw.com
Reported By: az@i7.com.au
Status: Closed
Bug Type: OCI8 related
Operating System: Linux 2.2, Solaris 2.6
PHP Version: 4.0.6
New Comment:
It seems, that I have the same problem using PHP 4.3.0 on Apache 1.3.22
with Oracle 8.1.7:
When I use a OciBindByName, the string is trimed at the end. This small
program uses the DUAL from Oracle just to return the input:
$conn = OciLogon ("x","y","z");
$val = " X X "; // last letter is a " " (blank)
// direct way without a bind variable
$stm1 = OciParse($conn, "select '".$val."' from dual");
OciExecute($stm1);
OciFetch($stm1);
echo "<b>", OciResult($stm1, 1), "</b><br>\n";
// now using a bind variable:
$stm2 = OciParse($conn, "select :input from dual");
OciBindByName($stm2, ":input", &$val, 10);
OciExecute($stm2);
OciFetch($stm2);
echo "<b>", OciResult($stm2, 1), "</b><br>\n";
OciLogoff($conn);
The output is:
<b> X X </b><br>
<b> X X</b><br>
But I want to get the same output for the direct way and when I use a
bind variable.
Thank you for any idea how to get the string with tailing spaces right
into Oracle using a bind variable.
Best wishes,
Jens
Previous Comments:
------------------------------------------------------------------------
[2002-04-13 08:58:13] thies@php.net
try storing in a varchar2 firld, if you use CHAR oracle will trim
traing spaces.
------------------------------------------------------------------------
[2001-11-11 06:49:19] az@i7.com.au
Erm, yeah, that's supposed to be '$id = 666;'.
------------------------------------------------------------------------
[2001-11-11 03:28:34] az@i7.com.au
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