Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Accented characters conversion

Vipul
New Contributor II
New Contributor II

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)"
]
}

2 REPLIES 2

Saathvik
All-Star
All-Star

@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)"


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star

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

Change file type to CSV Macnitosh

rushikeshvartak_0-1714099092322.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.