How to compare string with Latin characters to same string with English characters in IICS?

Question

For example, how to successfully compare "André" and "Andre"?

I tried some Reg_replace options without any success.

Answer 1

I don't think there is an out-of-the-box function available in IICS. Try using Java transformation to remove the diacritics. Here's one SO post I've found that should provide some help.

Note there may be some more up to date libraries now.