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:
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?