PostgreSQL Error

Hi,

We use Qlikview to report over our Service Desk Plus postgresql database via an ODBC connector. We pull in the records using the following query:

SELECT *

FROM servicedesk.public.workorder

Now this has been working for a while but has recently stopped because of the following error:

Error: SQL##f - SqlState: 22P05, ErrorCode: 1, ErrorMsg: ERROR: character with byte sequence 0xef 0xbb 0xbf in encoding "UTF8" has no equivalent in encoding "WIN1252"

I suspect this might be down to the ODBC connector not handling a certain character or something. I can run the query fine with no errors using Heidi over the database.

I cannot work out what is breaking it though. Any help would be greatly appreciated!

Thanks,
Lee