[paul2289]

I am connecting the suggest control to a Postgres database and have noticed that it is performing the queries case sensitive.
Looking at the logs on the database it is doing the following query

Code: Select all

Select field1,field2 FROM table1 LIKE "%search%"

To be case insensitive it should use ILIKE rather than LIKE.
Has anyone else had this issue?
Thanks.

[amosbatto]

I'm not sure where this is set.

In the file gulliver/methods/genericAjax.php, try changing from:

Code: Select all

    $sqlConditionLike = "LIKE '%" . $inputSel . "%'";

    switch ($searchType) {
        case "searchtype*":
            $sqlConditionLike = "LIKE '" . $inputSel . "%'";
            break;
        case "*searchtype":
            $sqlConditionLike = "LIKE '%" . $inputSel . "'";
            break;
    }

To:

Code: Select all

    $sqlConditionLike = "ILIKE '%" . $inputSel . "%'";

    switch ($searchType) {
        case "searchtype*":
            $sqlConditionLike = "ILIKE '" . $inputSel . "%'";
            break;
        case "*searchtype":
            $sqlConditionLike = "ILIKE '%" . $inputSel . "'";
            break;
    }

Does that fix it?