Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/25/2024 08:15 AM
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)"
]
}
04/25/2024 09:57 AM
04/25/2024 07:38 PM
UPDATE NEWUSERDATA a SET a.lastname = FN_EIC_REPLACE(a.lastname, null) COLLATE utf8_unicode_ci;
Change file type to CSV Macnitosh