Re: [GENERAL] invalid byte sequence for encoding error

2006-05-19 Thread Markus Wollny
Nis Jorgensen wrote: > Oliver A. Rojo wrote: >> how do you fix your original db? >> > > Since I had only 3 occurrences of the error, I used > hand-crafted update statements. The fact that the replacement > for the invalid characters was constant and plain ascii made > this very easy. > > If you

Re: [GENERAL] invalid byte sequence for encoding error

2006-05-19 Thread Oliver A. Rojo
Markus Wollny wrote: Nis Jorgensen wrote: Oliver A. Rojo wrote: how do you fix your original db? Since I had only 3 occurrences of the error, I used hand-crafted update statements. The fact that the replacement for the invalid characters was constant and plain ascii made this

Re: [GENERAL] invalid byte sequence for encoding error

2006-05-19 Thread Nis Jorgensen
Oliver A. Rojo wrote: 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 I fixed it by fixing the original db and dumping again. If this is not desi

Re: [GENERAL] invalid byte sequence for encoding error

2006-05-19 Thread Oliver A. Rojo
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 t

Re: [GENERAL] invalid byte sequence for encoding error

2006-05-19 Thread Nis Jorgensen
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

Re: [GENERAL] invalid byte sequence for encoding error

2006-05-18 Thread Oliver A. Rojo
Tom Lane wrote: "Oliver A. Rojo" <[EMAIL PROTECTED]> writes: 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 That's de

Re: [GENERAL] invalid byte sequence for encoding error

2006-05-18 Thread Tom Lane
"Oliver A. Rojo" <[EMAIL PROTECTED]> writes: > 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 That's definitely not valid UNICODE (UTF-

[GENERAL] invalid byte sequence for encoding error

2006-05-18 Thread Oliver A. Rojo
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. Please help! Thanks!