function offline_orders($term)
{
$sql = "SELECT O.order_date
, C.name
FROM offline_orders O
JOIN customers C ON O.customerid = C.customer_id
WHERE C.name LIKE :term";
$stmt = $this->pdo->prepare($sql);
$stmt->execute(array(':term' => '%'.$term.'%'));
return $stmt->fetchAll();
}
You can try and use a case insensitive collation on your query, like COLLATE UTF8_GENERAL_CI.
Try
$sql = "SELECT O.order_date
, C.name
FROM offline_orders O
JOIN customers C ON O.customerid = C.customer_id
WHERE C.name LIKE :term COLLATE utf8_general_ci";