The singlestore version we have is 7.8.4.
We are using singlestore pipeline to consume data directly from kafka and executing SP to process and store the data into tables.
The incoming kafka message might have special chars like emoji icons. We have set the charset to UTF-8mb4 at global level. But, still the messages are broken and it fails while parsing within the stored proc.
Is there any setting we are missing to deal with this?