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...........
mysql 'like' query problem for greek characters in php
Moderator: General Moderators
- iankent
- Forum Contributor
- Posts: 333
- Joined: Mon Nov 16, 2009 4:23 pm
- Location: Wales, United Kingdom
Re: mysql 'like' query problem for greek characters in php
Assuming the columns etc are all using the correct charset, try setting the charset before using your SELECT query:
replacing utf-8 with whichever charset you need
Code: Select all
SET NAMES utf-8;