Ankuj Gupta wrote:
For eg Select * from page where page_title='インド' is my query. How to execute this query on mysql tables as data is not stored in utf-8 format but the collation of page_title filed is latin_1
Try:
select * from page where page_title=convert('インド' using binary);
You should probably convert the tables from latin1 to binary to avoid future corruption.
-- Tim Starling