Github user mattyb149 commented on the issue: https://github.com/apache/nifi/pull/883 That part makes sense, but what about when I put three emoticons in the UpdateAttribute processor to set the value, then I get three bytes in the table, all value 63. I would've expected 6 bytes, two per smiley as a Unicode or UTF-16 value. I'll check the flow file to see if that's being done before PutSQL. Mostly I was testing other ways of getting binary data into the processor vs Avro, I don't have an Avro file with binary data in it. I'll create one and take it through the paces. Also I wonder what happens when you have binary data as the payload of a flow file and want to use that in PutSQL, using ExtractText to get it into an attribute.
--- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---