How to search with non utf chars in mysql and php

Question

I need to search from table, like

select * from geo where state='Grästorp'

But it does not give me any results. but when I run this query with phpmyadmin it gives me right result. How to search with in MySQL with non utf-8 chars?

this may help http://stackoverflow.com/questions/14256742/to-use-utf8-or-not-mysql-and-php-character-encoding-issue — Emilio Gort, Dec 12 '13 at 06:33

score 0 · Answer 1 · answered Dec 12 '13 at 06:40

0

select * from geo where state LIKE '%Grästorp%' collate utf8_bin;

answered Dec 12 '13 at 06:40

saloni

121
4

score 0 · Answer 2 · answered Dec 12 '13 at 10:24

0

you can try

SET NAMES 'utf8'

before querying anything else that has to do with unicode.

answered Dec 12 '13 at 10:24

sotoz

3,100
3
34
41

How to search with non utf chars in mysql and php

2 Answers2