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