Jan Walraven
DevOps



Categories:
  • Arduino (2)
  • CSS (3)
  • Docker (10)
  • ESXi (1)
  • Git (4)
  • Javascript (6)
  • Linux (31)
  • Mac (6)
  • Magento (4)
  • Mysql (13)
  • PHP (9)
  • Zend framework 2 (9)
  • 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) ,'%')