Strange character in retrieved data

[JohnP]

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 €

[Shalex]

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.

[JohnP]

Setting Unicode=True has resolved the issue

Many thanks.

[Shalex]

Thank you for your feedback.