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 €
Strange character in retrieved data
Re: Strange character in retrieved data
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.
Re: Strange character in retrieved data
Setting Unicode=True has resolved the issue
Many thanks.
Many thanks.
Re: Strange character in retrieved data
Thank you for your feedback.