ID: 44076
User updated by: jeff76 at operamail dot com
Reported By: jeff76 at operamail dot com
Status: Open
Bug Type: MySQL related
Operating System: FreeBSD
PHP Version: 6CVS-2008-02-08 (snap)
New Comment:
I did further testing, it seems the bugs shows up or not depending on
the blob field content itself :
- it works fine if the content is text (tried with both short strings
as well as 100 Kb+ ISO-8859-1 text files)
- it doesn't work with raw binary content (such as a JPEG file, however
short or long)
Also this is using MySQL 4.1 and InnoDB tables.
Previous Comments:
------------------------------------------------------------------------
[2008-02-12 21:13:52] [EMAIL PROTECTED]
Works fine to me.
PHP 6.0.0-dev (cli) (built: Feb 12 2008 18:56:58)
------------------------------------------------------------------------
[2008-02-08 08:12:57] jeff76 at operamail dot com
Description:
------------
It seems using mysql_result to retrieve a blob doesn't work and returns
nothing (NULL). Using a different function like mysql_fetch_assoc
however does work properly, as does reverting to PHP 5 or retrieving a
non-blob column.
This is using Unicode semantics.
Reproduce code:
---------------
(...connect to DB)
$res=mysql_query('SELECT blob_column FROM table WHERE condition');
$var=mysql_result($res, 0);
print_r($var);
echo(gettype($var));
Expected result:
----------------
(random binary garbage) and a proper variable type (unicode or binary
?)
Actual result:
--------------
gettype returns NULL, and print_r echoes nothing.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=44076&edit=1
