Fulltext search case conversion

Hello, I am writing a search routine and I have found a problem with my search that has to do with content case.

My search form uses utf-8, as the characters are Greek, and the input is correct but when searching mysql, I would like to know if there is any way to search it using lowercase.

I can convert the search input to lowercase correctly using:


$search = mb_strtolower($search, "UTF-8");

but as the content in the database is user inputted and includes words in a variety of case formats, it would be better to do the search in lowercase.

Here is what the mysql looks like:


    $db_return = implode(',',array_keys($db_fields) );
    if ($boolean == TRUE) {
        if ($testmode == true ) {
            echo "Was boolean <br />";
        }
        $s_char = ($split == 'OR' || $split == '')?"":"+";
        // Boolean query 
        $query = "SELECT $db_return, MATCH($db_query) 
        AGAINST ('$s_char$terms[0] $s_char$terms[1] $s_char$terms[2] $s_char$terms[3] $s_char$terms[4] $s_char$terms[5]' IN BOOLEAN MODE) AS relevance 
        FROM $db_table WHERE
        MATCH($db_query) AGAINST ('$s_char$terms[0] $s_char$terms[1] $s_char$terms[2] $s_char$terms[3] $s_char$terms[4] $s_char$terms[5]' IN BOOLEAN MODE)
        HAVING relevance > 0.2 ORDER BY $sort_order"; 
    } else { 
        // non-Boolean query, searches for exact phrase entered
        $query = "SELECT $db_return, MATCH($db_query) 
        AGAINST ('$trimmed' IN BOOLEAN MODE) AS relevance 
        FROM $db_table WHERE 
        MATCH($db_query) AGAINST ('$trimmed' IN BOOLEAN MODE)
        ORDER BY $sort_order"; 
    }

How can this be modified to search using mb_lowercase so that input and database data can be compared properly?

By the way:
The term fulltext does not always imply using the fulltext indexing option, or does it?

The information in the database is from a library and contains proper case of a surnames, book titles, and other info as entered by staff. The database is that of a multi-foreign language library with data recorded in upper/lower case and with accent marks.

I know that:
mysql fulltext search is case-insensitive
there must be less than 14 fields

While I would like to use the boolean search capability if it works in non-boolean mode that would be okay too.

I read 9.3.1. Character Definition Arrays in the mysql reference but can #define _MY_L 02 /* Lower case */ be used here, and if so how?

If this cannot be done using fulltext search, then can someone provide another alternative or suggestion?