Devart Forums

I'm using the DevArt Excel addin v 1.5.239.0 to retrieve data from a PostgreSQL database and am getting a strange character which doesn't exist in the database appearing in the Excel spreadsheet.

The text in the database field is (for example) UK Haulage - £2000 whilst the test displayed in the excel spreadsheet is UK Haulage - £2000

There is a space between the - and £ characters in the database

Any ideas what might be causing this and how I can resolve it ?

Update:
After further testing the $ symbol is retrieved correctly but the € is displayed as €

Please open the Connection Editor for your PostgreSQL connection and set Unicode=True via the Advanced menu. After this, refresh data in your Excel sheet. Does this help? If not, specify the exact data type of database column which stores currency symbols.

Setting Unicode=True has resolved the issue

Many thanks.

Thank you for your feedback.