I was wondering if there is a way for me to search for a non-accented value in SOQL and the results would bring me words with and without accent.
Example: I searched for "helló" and the result brings me records that have "helló" and "hello". Or i I searched for "hello" and the result brings me records that have "helló" and "hello".
Note: I know that in SOSL this search works, but in addition to what I requested, I also need to search for words that contain my searched string. And that the SOSL "FIND" does not. It only searches words that START with the searched value.
Then I could search: "hello" and the result would also bring me words like "thishello" "testhello" or "thishelló" "testhelló"....