Search Case Insensitive about datatables HOT 5 CLOSED

what db are you using ?

from datatables.

I have found the solution.

I removed the iteration for "each" word search. See below

$searchinput = (string)$this->input('search')['value'];
$length = strlen($searchinput);
$allcolumns = $this->input('columns');

    if ($searchinput == '' || $length < 2)
    {
        return null;
    }

    $search = [];
    $searchinput = preg_replace("/[^\wá-žÁ-Ž]+/", " ", $searchinput);
    $new_search = strtoupper($searchinput);

    $lookfor = [];
    foreach ($this->columns as $key => $column) {

        if(array_key_exists($key,$allcolumns)){

            if ($allcolumns[ $key ]['searchable'] == 'true') {
                $lookfor[] = "UPPER(".$column . ") LIKE  '%". $new_search . "%'  ";
            }
        }
    }
    $search[] = "(" . implode(" OR ", $lookfor) . ")";

I know I need to escape...But this gives the general direction.

from datatables.

And I am using a DB2, ibmi

from datatables.

As I thought, it is something related to DB. There is an article in this post about db2 which is you may have already be read.

it says:

The short answer is that DB2 for Linux®, UNIX®, and Windows® Version 7.2 is case sensitive: BLAIR is not the same as Blair.

Newer versions have the ability to create case insensitive databases. see : http://www.dbatodba.com/db2/db2-udb-v9/how-to-make-db2-v9-5-case-insensitive/

from datatables.

Yep. Thanks for the follow up...great package. Love it.

from datatables.