Support Questions
Find answers, ask questions, and share your expertise

ExecuteSQL processor can't insert to SQL server Unicode characters ?

Highlighted

ExecuteSQL processor can't insert to SQL server Unicode characters ?

New Contributor

Hi,

I'm using nifi to insert rows to sql server or postgres server, where some field values are unicode utf-8 strings with languages like Russian, Arabic etc'.

Before I execute the query that is passed form the file stream i can see that the non ASCII characters are OK.

In the table the value of the the field is changed to other characters like "?/?" and other strange characters.

I have tried to change the stream from utf-8 to utf-16 to see if it's fix the problem but it did not.