I'm using latest full version. Database is mysql
Need insensitive case searh
Typing in "Dog" will work
Typing in "dog" will not work.
My code:
$col = array();
$col["title"] = "Brand";
$col["show"] = array("list"=>true, "edit"=>true, "view"=>true);
$col["searchoptions"]["sopt"] = array("bw");
$col["name"] = "brand";
$col["width"] = "20";
$col["editable"] = true;
$cols[] = $col;
1 Answers
Refer this query for mysql case sensitive search:
http://stackoverflow.com/questions/3936967/mysql-case-insensitive-select
Your Answer