MySql check for non unicode characters

Asked Aug 05 '15 at 04:37

Active Aug 05 '15 at 04:37

Viewed 131 times

I have a table in mySql and some of the rows have an é. And when I am running my script to use the values in the mySql it breaks because of this. I am trying to find all the rows that contain an "é" but it doesn't work? Here is what I am trying:

SELECT * FROM `Schools_Geocode` WHERE `column` LIKE 'é'

How can I find row that contains é

asked Aug 05 '15 at 04:37

spen123

3,254
10
37
52

use this `LIKE '%é%'` – Abdulla Nilam Aug 05 '15 at 04:38
@Abdulla right. but that returned objects that any e not just é – spen123 Aug 05 '15 at 04:43
Possible duplicate http://stackoverflow.com/questions/500826/how-to-conduct-an-accent-sensitive-search-in-mysql – mongjong Aug 05 '15 at 04:47
check this tread http://stackoverflow.com/questions/6552950/mysql-matching-unicode-characters-with-ascii-version – Noman Aug 05 '15 at 05:45

MySql check for non unicode characters

0 Answers0