First off, sorry if the title is misleading. Didn't really know how to put it in a more exact fashion.
The problem as an example goes like this: In our Oracle-DB we have a row which contains a string-value (varchar2(120)) like 'XYZTǧ'. The use-case is, the frontend user wants to input 'XYZTg' and after clicking on the search button, still want to see the row containing the value 'XYZTǧ' returned.
My question is can i create a query that achieves this kind of behaviour? There are multiple cases like this: such as searching for value containing the character 'Ð' with an input containing 'D'. Any help is much appreciated.
Cheers.