"Unable to translate bytes" message with a PostgreSQL database

[jmleguedard]

Hello,

When I try to load a table of a PostgreSQL database, I get the following error message:

"DataSource.Error : Unable to translate bytes [C9] at index -1 from specified code page to Unicode"

I think that the encoding of the database (which is SQL_ASCII) is the problem, but I can't change it because I did not create the database, it comes from a manufacturing software.

Can anybody help me?

Thanks!

[v-yuezhe-msft]

@jmleguedard,

I would recommend you contact PostgreSQL support about how to change encording when selcting columns from table, then input the sql statement in the following textbox and check if you get any errors.



There is also an example for your reference.
https://gist.github.com/jpetitcolas/5967887


Regards,
Lydia