Accented characters conversion

[Vipul]

Hi,

I am trying to convert the accented characters from the lastname attribute of users to English characters using Saviynt OOTB functionality, i.e., FN_EIC_REPLACE(STRING_TO_BE_REPLACED,null), but it keeps throwing an error: "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='".

I am uploading the users through CSV, which has accented characters, and using the below preprocessor to convert them.

I have also attached the logs in here.

Has anyone seen a similar error before?

{
"ADDITIONALTABLES": {"USERS": "SELECT username,lastname FROM USERS"},
"COMPUTEDCOLUMNS": [
"username",
"lastname"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA a SET a.lastname = FN_EIC_REPLACE(a.lastname,null)"
]
}

[Saathvik]

@Vipul : Can you try to set to different column like customproperty to see if that works?

"UPDATE NEWUSERDATA a SET a.custompropertyxx= FN_EIC_REPLACE(a.lastname,null)"

[rushikeshvartak]

UPDATE NEWUSERDATA a SET a.lastname = FN_EIC_REPLACE(a.lastname, null) COLLATE utf8_unicode_ci;

Change file type to CSV Macnitosh