From: bogdan dot enache at intersat-telecom dot ro
Operating system: Windows XP
PHP version: 5.1.4
PHP Bug Type: MySQLi related
Bug description: When using collate no result set returned
Description:
------------
A query like:
SELECT * FROM view_cl_all WHERE cl_name LIKE '%ab%'
is working both in Query Browser and PHP. BUT,
SELECT * FROM view_cl_all WHERE cl_name LIKE '%ab%' COLLATE
utf8_general_ci
works (5 results) in Query Browser. If I run the same query in PHP, query
fails (returns NULL resultset).
Table type: InnoDB, charset: UTF8, collation: utf8_romanian_ci
Reproduce code:
---------------
So I have this PHP code:
if ($dbc->query($s)){
$ret = array();
if($res = $dbc->store_result()){
$no = $res->num_rows;
for($i = 0; $i < $no; $i++){
$ret[$i] = $res->fetch_assoc();
}
if($res){
$res->close();
}
return $ret;
}
}
else{
echo 'Query failed: '; var_dump($s);
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
}
exit;
return FALSE;
}
IF I set
$s="SELECT * FROM view_cl_all WHERE (cl_name LIKE '%al%' )"
it's working, i get a number of results.
But if
$s="SELECT * FROM view_cl_all WHERE (cl_name LIKE '%al%' COLLATE
utf8_general_ci)"
then query silently fails, no error, but NULL resultset.
--
Edit bug report at http://bugs.php.net/?id=38328&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=38328&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=38328&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=38328&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=38328&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=38328&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=38328&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=38328&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=38328&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=38328&r=support
Expected behavior: http://bugs.php.net/fix.php?id=38328&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=38328&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=38328&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=38328&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38328&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=38328&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=38328&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=38328&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=38328&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=38328&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=38328&r=mysqlcfg
