|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #5172 conversion of hex syskeys in prepared statements
Submitted: 2000-06-21 16:31 UTC Modified: 2000-07-31 21:49 UTC
From: k dot kleist at mediatransfer dot de Assigned:
Status: Closed Package: Adabas-D related
PHP Version: 4.0.0 Release OS: linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: k dot kleist at mediatransfer dot de
New email:
PHP Version: OS:


 [2000-06-21 16:31 UTC] k dot kleist at mediatransfer dot de
The conversion of an Adabas-D syskey in prepared statements don't work since php4.0RC1.
The following code discribes the problem:

$syskey = "00000000005A59AA"; // hex representation of an char(8)byte syskey

$query = "insert into table (id) values ( ?)";
$pre = odbc_prepare($conn, $query);
$data[0] = $syskey;
$result = odbc_execute($pre, $data);

The odbc_execute command will produce the following error:
               String data, right truncated
error-code: 743
State: 01004

When I'm inserting a substring of the key ($data[0] = substr($syskey, 8) it works, but it isn't the same key!!!


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2000-07-31 21:49 UTC]
As I can figure out, you?ve choosen the column width 8, in
fact it has to be longer. Your 8Byte syskey is of course
8Bytes long, but your representation is 16 chars long (count
your chars).
This is no PHP bug. Extend you col size.
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Fri Aug 07 03:01:23 2020 UTC