Search for special chars in latin1_swedish
Posted on October 7, 2012
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) ,'%')