How to remove accented characters for email generation logic?

[anujapawar]

Hi,

I wrote the following logic to remove accented characters from the email generation rule. But after running this query it drops the accented character and forms email without including them.

Query: - 

FN_EIC_MAPPING((CASE
WHEN users.preferedfirstname IS NOT NULL AND trim(users.preferedfirstname <> ' ') THEN REPLACE(CONCAT(users.preferedfirstname,'_',users.lastname,'@xyz.com'), ' ', '_')
ELSE
REPLACE(CONCAT(users.firstname,'_',users.lastname,'@xyz.com'), ' ', '_')
END),null) #

Output:

This query just drops the accented character.

Please let me know how I can normalize it?

[rushikeshvartak]

what is characters specified in REPLACE_MAPPING dataset for replacement