mysql> set names 'utf8';
Query OK, 0 rows affected (0.00 sec)

mysql> select subject, HEX(subject) FROM issues WHERE subject LIKE '%idup%';
+-------------------+------------------------------------+
| subject           | HEX(subject)                       |
+-------------------+------------------------------------+
| Sõidupäevik     | 53C3B569647570C3A46576696B         |
| Sõidupäevik | 53C383C2B569647570C383C2A46576696B |
+-------------------+------------------------------------+
2 rows in set (0.00 sec)

mysql> set names 'latin1';
Query OK, 0 rows affected (0.00 sec)

mysql> select subject, HEX(subject) FROM issues WHERE subject LIKE '%idup%';
+---------------+------------------------------------+
| subject       | HEX(subject)                       |
+---------------+------------------------------------+
| S?idup?evik   | 53C3B569647570C3A46576696B         |
| Sõidupäevik | 53C383C2B569647570C383C2A46576696B |
+---------------+------------------------------------+
2 rows in set (0.00 sec)