You can select from a table and set the collation to be used for the search.


SELECT * FROM my_table WHERE my_field = 'hallå';
SELECT * FROM my_table WHERE my_field COLLATE utf8_swedish_ci = 'hallå';