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

Already on GitHub? Sign in to your account

There's no way to allow a zero character in PostgreSQL, and oracle_fdw does not have any provisions for modifying the data it gets from Oracle.

Is the zero byte in the character string in the Oracle database intentional?
If not, maybe they would even be interested in fixing it; zero bytes in strings cause all sort of trouble.

use select translate( column, chr(0),' ' )

in select to convert the invalid byte sequenzes in oracle to something else in oracle
(during selection or update the tables in oracle to remove them )

pg gives you the column names and the invalid codes

before loading into pg I have to do a lot of updates, because the oracledb is infested with this crap,
especially email data