ID: 35155
Updated by: [EMAIL PROTECTED]
Reported By: f dot engelhardt at 21torr dot com
-Status: Bogus
+Status: Closed
Bug Type: MySQLi related
Operating System: Linux 2.6
PHP Version: 5CVS-2005-11-09 (snap)
Assigned To: andrey
New Comment:
Well not bogus. This is fixed in the upcoming 5.1.0 . AFAIK there will
be no release in the 5.0 branch after 5.0.5 where the problem exists.
Previous Comments:
------------------------------------------------------------------------
[2005-11-21 22:06:05] [EMAIL PROTECTED]
Z_STRLEN_PP() macro does not use the strlen() function. It's a macro to
access the real length from the zval** (PP). So, from what I see it
should work correctly. PHP reads the file and is \0 aware so the length
in the zval that represents the string should be ok.
I have done a test and for me it seems to work ok. See the md5() hash
of what's in the column. Just mysql cmdline client does not show the
whole string but stops at the \0. Try with the function LENGTH() and it
will work (shows 8 for me).
mysql> create table blob_test (a mediumblob);
Query OK, 0 rows affected (0.19 sec)
-----------------------------------------------------
php -r '
$c=new mysqli("127.0.0.1", "root","");
var_dump($c);
$s=$c->prepare("INSERT INTO test.blob_test VALUES(?)");
$v="aaaa\0bbb";
$s->bind_param("s",$v);
var_dump($s->execute(), $s->execute());'
-------------------------------------------------------
mysql> select md5("aaaa"), md5("aaaa\0bbb"), md5(a), a from
blob_test\G
*************************** 1. row ***************************
md5("aaaa"): 74b87337454200d4d33f80c4663dc5e5
md5("aaaa\0bbb"): f04bbe8400c631e6bab90d30900ccc69
md5(a): f04bbe8400c631e6bab90d30900ccc69
a: aaaa
*************************** 2. row ***************************
md5("aaaa"): 74b87337454200d4d33f80c4663dc5e5
md5("aaaa\0bbb"): f04bbe8400c631e6bab90d30900ccc69
md5(a): f04bbe8400c631e6bab90d30900ccc69
a: aaaa
2 rows in set (0.00 sec)
------------------------------------------------------------------------
[2005-11-17 08:33:56] f dot engelhardt at 21torr dot com
Is there someone working on the bug, i havent heard anything for a
couple of days now.
------------------------------------------------------------------------
[2005-11-14 12:07:04] f dot engelhardt at 21torr dot com
Note: with the PDO it is working as expectet, but we can not use
software that is still in a beta stadium.
------------------------------------------------------------------------
[2005-11-12 01:22:11] [EMAIL PROTECTED]
Georg, see the feedback.
------------------------------------------------------------------------
[2005-11-11 11:33:32] f dot engelhardt at 21torr dot com
case MYSQL_TYPE_VAR_STRING:
convert_to_string_ex(&stmt->param.vars[i]);
stmt->stmt->params[i].buffer = Z_STRVAL_PP(&stmt->param.vars[i]);
stmt->stmt->params[i].buffer_length =
strlen(Z_STRVAL_PP(&stmt->param.vars[i]));
break;
php-5.0.5/ext/mysqli/mysqli_api.c:574
This line is the problem, you can not use strlen to read the length of
binary data, or this convert_to_string_ex() function destroys the
data.
Kind regards
Florian Engelhardt
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/35155
--
Edit this bug report at http://bugs.php.net/?id=35155&edit=1
