I am trying to use Sqoop Export to Export Data from HDFS to Netezza table. And I am facing issue with few of french characters. I have table with just only one column and one row as mentioned below.
En fil métallique résistant mâchouillag
Problem: When I use sqoop to export these data to Netezza table, I get following row as compared to mentioned above.
En fil meÌtallique rÃ©sistant maÌchouillag
It seems like there is any issue with the Netezza JDBC driver I am using to export, I should specify somewhere the encoding or something like that. However, I am not sure.
Could someone please let me know how to fix this issue.