some times in jquery-bootgrid to search Chinese text,you will get no results.there are not problem of jquery bootgrid,but may be searched mysql fields type problem,for example,you could not get search result when some field type is datetime.
so you could get a if to judge which field fit for do chinese text search,like:
if (preg_match("/[\x7f-\xff]/", $searchPhrase)) {//contain chinese text
$where=array(
'deposit_type %'=> '%'.$searchPhrase.'%',
);
}else{
$where=array(
'|lilv_changed_time %'=> '%'.$searchPhrase.'%',
'|deposit_time %'=> '%'.$searchPhrase.'%',
'|deposit_type %'=> '%'.$searchPhrase.'%',
'|lilv %'=> '%'.$searchPhrase.'%'
);
}
some times in jquery-bootgrid to search Chinese text,you will get no results.there are not problem of jquery bootgrid,but may be searched mysql fields type problem,for example,you could not get search result when some field type is datetime.
so you could get a if to judge which field fit for do chinese text search,like:
if (preg_match("/[\x7f-\xff]/", $searchPhrase)) {//contain chinese text $where=array( 'deposit_type %'=> '%'.$searchPhrase.'%', ); }else{ $where=array( '|lilv_changed_time %'=> '%'.$searchPhrase.'%', '|deposit_time %'=> '%'.$searchPhrase.'%', '|deposit_type %'=> '%'.$searchPhrase.'%', '|lilv %'=> '%'.$searchPhrase.'%' ); }