0

I inserting data from mysql to postgresql using Talend and I get invalid byte sequence error. I used trim(both CHAR(0x00) from column_name) to remove invalid characters. It removed most of the errors but I am guessing there are invalid characters in the middle of string. How can I find and remove them using sql?

Rick James
  • 135,179
  • 13
  • 127
  • 222
jmf
  • 356
  • 5
  • 25
  • Possible duplicate of [How to remove bad characters that are not suitable for utf8 encoding in MySQL?](http://stackoverflow.com/questions/13657019/how-to-remove-bad-characters-that-are-not-suitable-for-utf8-encoding-in-mysql) – matfax Mar 24 '17 at 14:30
  • *How* do you insert data from MySQL to PostgreSQL? With a program? In which language is the program written? – Laurenz Albe Mar 24 '17 at 14:30
  • I am using Talend for ETL – jmf Mar 24 '17 at 15:22

0 Answers0