In my site I am storing tamil,hindi contents and store it in database using utf-8 data.I am using fulltext search for searching from the database and getting results.But search is not working if I search for tamil or hindi content.
Can anyone help me to solve this issue pls.
Again, please provide relevant details if you expect help with your questions. We can’t guess at the data, the query nor the results.
Sorry for late reply.
Im my database the values are stored like this,
à®¨à¯€à®™à¯à®•à®³à¯à®®à¯ à®¤à®®à®¿à®´à®¿à®²à¯ à®Žà®´à¯à®¤à®²à®¾à®®à¯
நீங்களும் தமிழில் எழுதலாம்
If I search in the database using php like
“select * from table where match(subject) against (‘நீங்களும் தமிழில் எழுதலாம்’)”
But I can’t get any result since the databse contains decoded values.
Can anyone tell me a good soultion.