HI All,
I have a requirement to process a CSV file to my database. i have used a smart service(Export CSV to Database) from Excel Tools plugin. But some of the special characters are not read properly.For example:
The data i have received in CSV has : ~@ö<é;ó¿üäÖÇ*àÄ=É!"ѧæñ á½èçòíê°
after consuming the file i have got this in my database : ~@�<�;�����*��=�!"ѧ��������
Can anyone suggest if we have any alternative options for this please.
Thanks,Sai Kiran Pannala.
Discussion posts and replies are publicly visible
So, you export data from Appian into a CSV and import it, where? Appian uses UTF-8 to export the data. Is the other DB set up to store unicode? Does the import read the data in unicode?
HI Stefan,
Apologies if my statements were unclear.I am not exporting data from APPIAN.Basically i am getting data in a CSV file through SFTP integration from an external source. We need to consume that file into pur APPIAN database.While consuming the file i am using a smart service(Export CSV to Database) from Excel Tools plugin. And this smart service or plugin is unable to read few special characters as mentioned above.
I think the plugin expects the data to be encoded in UTF-8. Please check that.
It worked when i converted the CSV file with UTF-8 encoding and then run it. Thanks alot for the quick help.