https://community.qlik.com/t5/Data-Quality/Getting-Error-for-Emoji-and-Special-Characted/m-p/2470593#M4060 <P>Hi,&nbsp;</P> <P>&nbsp;</P> <P>We've been getting Talend Run Errors due to data entries with special character/ emojis. What we do is to locate that and update it. Is there a better way that these entries can be processed without getting rejetced?</P> <P>Sample error log:</P> <P><STRONG>java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\x87\xAE\xF0\x9F...' for column 'attendee_orgn_alias_nm' at row 3844</STRONG></P> Mon, 15 Jul 2024 07:48:03 GMT INF1984 2024-07-15T07:48:03Z https://community.qlik.com/t5/Data-Quality/Getting-Error-for-Emoji-and-Special-Characted/m-p/2470593#M4060 <P>Hi,&nbsp;</P> <P>&nbsp;</P> <P>We've been getting Talend Run Errors due to data entries with special character/ emojis. What we do is to locate that and update it. Is there a better way that these entries can be processed without getting rejetced?</P> <P>Sample error log:</P> <P><STRONG>java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\x87\xAE\xF0\x9F...' for column 'attendee_orgn_alias_nm' at row 3844</STRONG></P> Mon, 15 Jul 2024 07:48:03 GMT https://community.qlik.com/t5/Data-Quality/Getting-Error-for-Emoji-and-Special-Characted/m-p/2470593#M4060 INF1984 2024-07-15T07:48:03Z https://community.qlik.com/t5/Data-Quality/Getting-Error-for-Emoji-and-Special-Characted/m-p/2481637#M4081 <P>I've having the same issue here. No special characters despite the setting status.</P> <P>Were you able to solve this?</P> Sun, 15 Sep 2024 10:02:27 GMT https://community.qlik.com/t5/Data-Quality/Getting-Error-for-Emoji-and-Special-Characted/m-p/2481637#M4081 regaru 2024-09-15T10:02:27Z