Re: invalid byte sequence for encoding error

Nis Jorgensen wrote:

> Oliver A. Rojo wrote:
>
>> Hi!
>>
>> I've just recently upgraded my database from 7.4.8 to 8.0.1. Im
>> dumping data i got from my old db to my new db but eventually an
>> error occured
>>
>> ERROR: invalid byte sequence for encoding "UNICODE": 0xd141
>>
>> I tried setting the client encoding to UNICODE but to no avail.
>
>
> I had exactly the same problem (7.4.7 -> 8.1.3). Apparently older pg
> versions allowed for storing invalid utf-8 in text fields (ie the
> engine did not check the bytes going in).
>
> I fixed it by fixing the original db and dumping again. If this is not
> desirable you can of course restore to a clean 7.4.8, fix, dump.
>
> /Nis
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
hi!
how do you fix your original db?

--

Oliver A. Rojo

______________________________________________________________

This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. If you have received this email in error
please notify the system manager. Please note that any views or
opinions presented in this email are solely those of the author
and do not necessarily represent those of the company. Finally,
the recipient should check this email and any attachments for the
presence of viruses. The company accepts no liability for any
damage caused by any virus transmitted by this email.