#38328 [Opn->Fbk]: When using collate no result set returned

ID: 38328 Updated by: tony2001@php.net Reported By: bogdan dot enache at intersat-telecom dot ro -Status: Open +Status: Feedback Bug Type: MySQLi related Operating System: Windows XP PHP Version: 5.1.4 New Comment: Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If possible, make the script source available online and provide an URL to it here. Try to avoid embedding huge scripts into the report. Previous Comments: ------------------------------------------------------------------------ [2006-08-04 13:31:32] bogdan dot enache at intersat-telecom dot ro 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 this bug report at http://bugs.php.net/?id=38328&edit=1