search

isapir / Migrate2Postgres

Easily migrate from other DBMSs to PostgreSQL
GNU General Public License v3.0
52 stars 23 forks source link

Insert Failed. org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 #9

Closed sriram073 closed 5 years ago

sriram073 commented 5 years ago

Insert is failing for NULL values. Can you please help here how we can fix this issue. Below is error message.

"Insert Failed. org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00

    INSERT INTO public.ANSWER_TYPE (ID, NAME)
    VALUES('1', '☺☺   ]?ùf°ß?6?FP?¬,Å?? →Cû???6-sg↔?W»');

Insert Failed. org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00"

sriram073 commented 5 years ago

Issue with not Null values, those columns data was encrypted by application team. Worked with application team and issue was resolved.