When i am querying as400 with queryDatabaseTable the nifi is changing the 'char' type from the source to 'binary' type so as a result useless data is coming.What could be the possible solution for this?I have already set use 'avro logical type' to false.
It is going to be based on the JDBC type that the driver you are using is returning for the column...
My guess is that its not returning CHAR because that would have been converted to a string.
The types that are converted to bytes are:
BINARY, VARBINARY, LONGVARBINARY, ARRAY, BLOB