I have a search script which essentially just searches a list of soccer player's names and returns a list of those that match the search criteria.
$get_players = mysql_query(" SELECT CONCAT(PlayerLastName, ', ', PlayerFirstName) AS name, PlayerID AS id, DATE_FORMAT(PlayerDOB, '%Y') AS dob FROM tplss_players WHERE CONCAT(PlayerFirstName, ' ', PlayerLastName) LIKE '%$result%' OR PlayerFirstName LIKE '%$result%' OR PlayerLastName LIKE '%$result%' ORDER BY PlayerLastName, PlayerFirstName ASC ", $connection);
The problem is, if a player has an accented character in their name and the person searching isn't aware of it, it wont display them in the results.
I.e. Nadir Çiftçi. If someone searches for "Nadir Ciftci", nothing will come up.
Is there a way to configure your query so that accented characters are treated as normal characters? i.e. Ç is C?
The fields in question (PlayerFirstName and PlayerLastName) are set to use Collation of "utf8_bin".
Thanks in advance for any help you can offer,