How to modify this search?

I have the following search code on a page using the webasssist recordset... but it seems to be case sensitive. How do I change this so that it doesn't care about case?

$Recordset1 = new WA_MySQLi_RS("Recordset1",$DNSTags_i,0);
if (isset($_REQUEST['search']) && !empty($_REQUEST['search'])) {
$columns = ['TagTitle'];

// look for exact search
$booleanSearch = NULL;
if ($_REQUEST['search'][0] === "\"" && substr($_REQUEST['search'], -1) === "\"")
$booleanSearch = "IN BOOLEAN MODE";

// map search to query
$Where = " WHERE MATCH(". implode(',', $columns) .") AGAINST (? $booleanSearch)";
$SQL = "SELECT * FROM TAGS" . "$Where";

// may need to be filtered
$Recordset1->bindParam('s', $_REQUEST['search']);
$Recordset1->setQuery($SQL);
} else {
$Tracks->setQuery("SELECT * FROM TAGS");
}
$Recordset1->execute();

This is done in the database using phpMyAdmin.

Go to the column you are searching and change the collation to something that ends with "_ci"... those stand for "case insensitive".

After that change all searches against that column will be case insensitive.

Interesting, it's already set to latin1_general_ci. Other thoughts?

What is set to latin1_general_ci? All of the columns in the search and the table?

Is your query running with: IN BOOLEAN MODE? I think that may be removing the case insensitivity. Try removing that and see if you get the same result.

Yes, we were using a boolean qualifier.. removing that did fix the capitalization question, but now SOME search results are coming up, but not others. I'll look at records to try and see if I can see why, but it's a mystery. I can see the Title in the database with the words I'm searching on. The record is there but not coming up in the results. But another set of words for another record come up just fine. Shouldn't it work the same for all?

I would think so. I couldn't diagnose this without digging in and doing debugging.