Snippets
DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Benoit has posted 48 posts at DZone. View Full User Profile

Query MySQL Accent Insensitive In Latin1_general_ci

06.21.2008
| 5539 views |
  • submit to reddit 
        Query MySQL accent insensitive in latin1_general_ci


SELECT * FROM `table`WHERE `text` LIKE CONVERT(_utf8 '%cinema%' USING utf8) COLLATE utf8_general_ci ;


<a href="http://www.ab-d.fr/">Source: </a><a href="http://www.ab-d.fr/date/2008-06-21/">Query MySQL accent insensitive in latin1_general_ci</a>
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers