Solved

Combined filter and ASCII characters

  • 23 May 2022
  • 1 reply
  • 41 views

Userlevel 1
Badge +4

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’ ?

 

 

icon

Best answer by Mark Jongeling 23 May 2022, 10:54

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +23

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.