In the combined filter we have enabled searching on city.
We have records in the database with special ASCII characters in the name of the city like Årslev or Brønderslev in Denmark.
When typing ‘Arslev’ or ‘Bronderslev’ in the combined search, then these records are not found.
Is there an option that these records are also shown when typing the ‘regular’ ?
Best answer by Mark Jongeling
Hi,
You can make use of the Extended property: IgnoreDiacritics. (Docs) Value: Yes/No (No is default)
This will make sure you can search up the places without having to be a guru in typing those letters 😉 Do make sure the column you are trying to search in is of type NVARCHAR.
+23Hi,
You can make use of the Extended property: IgnoreDiacritics. (Docs) Value: Yes/No (No is default)
This will make sure you can search up the places without having to be a guru in typing those letters 😉 Do make sure the column you are trying to search in is of type NVARCHAR.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
