-1

I have created a search page where user can make search for visiting places of the different countries. In the database the address is stored in the English language and the result is shown from '%like%' query. It will give right result whenever someone search the address in the English language but no result found when someone search in the other language. I have tried to make change the search term in the English language and then make query but I has also a limitation. So what will I do to make my search work perfectly. Please help

Improve this question
1
  • You will need a translation table / dictionary inside your database to extend the used query or create a two-step search mechanism (i.e. query a translation service prior to searching your database). Commented Jan 3, 2016 at 16:32

1 Answer 1

Reset to default
-1

Please check your field collation. It should be utf8_general_ci.

May this links will help you.

link1

Link2

Link3

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.