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
_______________________________________________
Wikipedia-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikipedia-l
