Hi,
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.
Hi,
Sorry for late reply.
Im my database the values are stored like this,
நீஙà¯à®•à®³à¯à®®à¯ தமிழில௠எழà¯à®¤à®²à®¾à®®à¯
which means
நீங்களும் தமிழில் எழுதலாம்
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.