Search Postgresql Archives

Re: invalid byte sequence for encoding error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux