By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement . We’ll occasionally send you account related emails.

Hello,

Thank you for your work, it's beneficial.

I got a little problem with some tables. (Generated with schema)
I'm trying to select my table but there is an encoding conversion problem.

ERROR: invalid byte sequence for encoding "UTF8": 0x00
CONTEXT: converting column "nomfour" for foreign table scan of "d_article", row 43
SQL state: 22021

As I saw some FDW options can give some errors I checked for my configuration.

In ORACLE the field is a VARCHAR2(6) and in Postgres, it converts into a character varying.

Do you know where the problem can be?

Have a nice day,

That's a duplicate of #114 , #120 , #310 and #441 .

NUL characters (ASCII 0) are not allowed in PostgreSQL, that's why you get that error message.

The easiest solution is to use the strip_zeros option:

ALTER FOREIGN TABLE d_article ALTER nomfour OPTIONS (ADD strip_zeros 'on');