rekha_shp — 2010-03-17T01:57:32-04:00 — #1
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.
guelphdad — 2010-03-17T09:47:08-04:00 — #2
Again, please provide relevant details if you expect help with your questions. We can't guess at the data, the query nor the results.
rekha_shp — 2010-03-20T03:38:38-04:00 — #3
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.