subject:"\[GENERAL\] utf8 issues"

[GENERAL] utf8 issues

2015-02-25 Thread Felix Ivan Romero Rodríguez

I've got the followin issue with postgres 9.3, trying to restore a backup from sql script: invalid byte sequence for encoding “UTF8″: 0xc2de how can i solve it?

Re: [GENERAL] utf8 issues

2015-02-25 Thread Adrian Klaver

On 02/25/2015 07:11 AM, Felix Ivan Romero Rodríguez wrote: I've got the followin issue with postgres 9.3, trying to restore a backup from sql script: invalid byte sequence for encoding “UTF8″: 0xc2de how can i solve it? Provide more information:) Where is backup coming from , another

Re: [GENERAL] utf8 issues

2015-02-25 Thread Vick Khera

Fix the character sequence to be valid UTF8 before you restore it. I'm assuming you're restoring from a pretty old version of Postgres which did not do strict UTF8 character validation. Are you sure the data is encoded as UTF8 and not some other?