Sample Header Ad - 728x90

Match similar special character in filters

0 votes
1 answer
166 views
I have to perform a search on a table with Turkish city names. The users would enter the first 4 characters of a city and I need to fetch the results from SQL. For example, user wants to find the entries for Istanbul, so he would enter ista or Ista or ISTA Problem is that Istanbul is written with special character. It is Ìstanbùl. So my query where UPPER(city) like 'UPPER()%' will not find it. It only finds it when the user enters Ìsta (with the special character). Is there a way of converting similar special character to 1 character. So for example ìíî will be converted to i. This way a user can find Ìnstanbùl with whatever variant of i they enter.
Asked by roel (113 rep)
Apr 5, 2017, 08:32 AM
Last activity: Jul 7, 2025, 11:05 AM