DevOps, CI/CD and Automation

Hi,

I woul like to know how I do compare 2 strings containing a german umlaut.

For example I am using a parameter P containing a search string I want to compare with a german word like 'im Gespräch'.

Comparing the parameter P with the search string in a query like this:

select ...
...
where :P = 'im Gespräch'
;

does not work because the database nls parameters are different to german.

I tried using a "trick" replacing all characters except A-Z and 0-9 with a '#' using regexp_replace functions.

The result is strange because selecting "regexp_replace('im Gespräch', '[^A-Za-z0-9]', '#')" results in 'im#Gespräch'.

Does anyone have an idea how to solve that problem?

Thanks