From: [EMAIL PROTECTED]
Operating system: Redhat-6.2
PHP version: 4.1.1
PHP Bug Type: ODBC related
Bug description: problems w/ db2 char() for bit data
I configured php-4.1.1 as follows:
./configure --with-mysql=usr
--with-apache=/usr/local/apache/src/apache_1.3.22
--with-ibm-db2=/home/flexadm/sqllib --enable-track-vars
It seems to work okay, but all of the keys in our database are defined as
TECH_ID CHAR(13) FOR BIT DATA NOT NULL. This is then automatically
generated with the GENERATE_UNIQUE() function of DB2.
PHP appears to have problems working with this type of data. As the
following code has problems on my system:
<?php
$con = odbc_pconnect("database", "username", "password")
or
die("odbc_pconnect() failed.<br>\n");
$rs = odbc_exec($con, "SELECT TECH_ID FROM LOGON WHERE LOGIN_NAME =
'sbr'");
if(odbc_fetch_row($rs))
$tech_id = odbc_result($rs, "tech_id");
else
die("Could not find tech_id<br>\n");
$rs = odbc_exec($con, "SELECT LOGIN_NAME FROM LOGON WHERE TECH_ID =
".$tech_id);
if(odbc_fetch_row($rs))
$login = odbc_result($rs, "login_name");
else
$login = "UNKNOWN";
echo "TECH_ID: ".$tech_id."<br>\n";
echo "LOGIN: ".$login."<br>\n";
?>
The above code yields the following results in the browser:
Warning: SQL error: [IBM][CLI Driver][DB2/SUN] SQL0007N The character " "
following "OGON WHERE TECH_ID =" is not valid. SQLSTATE=42601 , SQL state
42601 in SQLExecDirect in /home/jfreed/public_html/debug.php on line 13
Warning: Supplied argument is not a valid ODBC result resource in
/home/jfreed/public_html/debug.php on line 14
TECH_ID: 'EbR
LOGIN: UNKNOWN
This lead me to try the odbc_binmode() function. So I added the following
line to my code (right under the initial odbc_exec() call:
odbc_binmode($rs, ODBC_BINMODE_CONVERT);
Now the output is as follows:
Warning: SQL error: [IBM][CLI Driver][DB2/SUN] SQL0401N The data types of
the operands for the operation "=" are not compatible. SQLSTATE=42818 , SQL
state 42818 in SQLExecDirect in /home/jfreed/public_html/debug.php on line
15
Warning: Supplied argument is not a valid ODBC result resource in
/home/jfreed/public_html/debug.php on line 16
TECH_ID: 20010504142745046252
LOGIN: UNKNOWN
Now, when I'm using the DB2 CLI to do this kind of stuff, I get the tech_id
as:
x'2001050412745046252000000'
This leads me to believe that we're on the right track here, just that
perhaps PHP is not translating this binary data quite properly.
Please let me know if you have any advice. I would be very grateful to
find a way around this problem as my company would require this to work in
order to move from CGI to PHP.
Thanks for your time.
--
Edit bug report at: http://bugs.php.net/?id=14851&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
