topic Re: Error while appending data to external postgres database in SAS Programming

Error while appending data to external postgres database

kaziumair — Thu, 02 Dec 2021 07:02:36 GMT

Hi ,

I am trying to append data from a SAS table to an external postgres table using the append procedure.

However while running the proc, I am getting the error "ERROR: CLI execute error: Error: invalid byte sequence for encoding "UTF8": 0xe2 0x2c 0x55"

Any idea how I can resolve this error?

Thanks and Regards,

Mohammad Umair Kazi

LinusH — Thu, 02 Dec 2021 07:31:09 GMT

My first guess would be that you try to ingest UTF8 data in a non UTF8 DB.

Check your database what encoding it uses (and compare with your SAS encoding).

kaziumair — Thu, 02 Dec 2021 07:32:14 GMT

Hi ,

I have checked the encoding it is UTF8.