Ankuj Gupta schreef:
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 as it displays weird characters and thus no result is displayed. If i try the php function utf_decode still it does not work.
I'm not sure whether you're asking this question on the API list, since it's intended for questions about the API, which you're not using.
Anyway, you could try pointing a MediaWiki install to use the database you're querying, and use api.php?action=query&titles=Whatever , which should work correctly.
Roan Kattouw (Catrope)