QVX_UNEXPECTED_END_OF_DATA if a string contains emojis

[nikolaus]

Hello,

I am reading data from an ERP system and one table contains mails with subject, sender and other fields.

Now I get a few mails where creative advertising guys send emojis as part of the subject. Like this:

Jetzt von den vielen Vorteilen von OnFarming profitieren! 🌾🐮🚜

So far I identified the senders and excluded them.When I run the same query in an SQL tool it works fine.

Is there a better way to replace or remove emojies from a query?

Thanks

Niko