I have a mySQL database which has some columns storing non-english characters. When I try to retrieve the characters i get them properly displayed. But when i try to do a filter with non-english characters on the db columns, it returns nothing. What should I do to make mySQL understand my language?

thanks
Sudharsan