Page 1 of 1

mysql 'like' query problem for greek characters in php

Posted: Sat Nov 21, 2009 8:41 am
by kashyap
hi,

When i run this qurey in mysql :-
SELECT id, title
FROM movie
WHERE title LIKE 'δ%'
LIMIT 0 , 30

then out put :-
id title
1 δοκιμή 123
2 δοκιμή


but when i run it in php then there is no any result
how to solve this problem..........?

Plz help me to solve it...........

Re: mysql 'like' query problem for greek characters in php

Posted: Sat Nov 21, 2009 8:44 am
by iankent
Assuming the columns etc are all using the correct charset, try setting the charset before using your SELECT query:

Code: Select all

SET NAMES utf-8;
replacing utf-8 with whichever charset you need