I'm working on migrating data from an oracle database to a postgresql database. I running into a problem where I export the data from oracle, using sql developer, and importing it into postgresql. When I try to import the data into postgresql I get this error:
ERROR: invalid byte sequence for encoding "UTF8": 0xcb 0xcf
CONTEXT: COPY project, line 646
********** Error **********
ERROR: invalid byte sequence for encoding "UTF8": 0xcb 0xcf
SQL state: 22021
Context: COPY project, line 646
The data in the oracle server looks like this in sql developer:
Ã9ÃýÃ0Ã
When sql developer exports the data to a file, it looks like this:
When I try to set the encoding in sql developer when I export the data I get this loading menu item:
and it doesn't change.
What do I need to do to properly export and import the data from oracle and postgresql?