Search for special chars in latin1_swedish

When you like to search for special chars in latin1_swedish, you can change the collate in your query:

SELECT * FROM `relation` WHERE 
`name` COLLATE latin1_general_cs LIKE CONCAT('%', char(195) ,'%')