Re: [GENERAL] Locale/encoding problem/question

2006-08-04 Thread henka
> [EMAIL PROTECTED] writes: >>> It should be in the dump file, almost the first line. Locale is of no >>> interest to pg_dump, you'll have to decide how you want it. > >> Yes: UTF-8 and the other is LATIN1 > > Note that this represents what the original server *thought* the > encoding was. But

Re: [GENERAL] Locale/encoding problem/question

2006-08-04 Thread Tom Lane
[EMAIL PROTECTED] writes: >> It should be in the dump file, almost the first line. Locale is of no >> interest to pg_dump, you'll have to decide how you want it. > Yes: UTF-8 and the other is LATIN1 Note that this represents what the original server *thought* the encoding was. But it's not at a

Re: [GENERAL] Locale/encoding problem/question

2006-08-04 Thread henka
> On Fri, Aug 04, 2006 at 11:58:22AM +0200, [EMAIL PROTECTED] wrote: >> > On Fri, Aug 04, 2006 at 10:48:17AM +0200, [EMAIL PROTECTED] wrote: >> > Two big questions: >> > >> > 1. What encoding are the two database (\l will tell you)? >> > 2. What encoding are the clients expecting? > >> I've even

Re: [GENERAL] Locale/encoding problem/question

2006-08-04 Thread Martijn van Oosterhout
On Fri, Aug 04, 2006 at 11:58:22AM +0200, [EMAIL PROTECTED] wrote: > > On Fri, Aug 04, 2006 at 10:48:17AM +0200, [EMAIL PROTECTED] wrote: > > Two big questions: > > > > 1. What encoding are the two database (\l will tell you)? > > 2. What encoding are the clients expecting? > I've even tried using

Re: [GENERAL] Locale/encoding problem/question

2006-08-04 Thread henka
> On Fri, Aug 04, 2006 at 10:48:17AM +0200, [EMAIL PROTECTED] wrote: >> Hello all, >> >> I somehow managed to stuff up the encoding (or locale or something) in a >> transfer of a database from one machine to another (also different linux >> distribution). >> >> The problem is this: the origional

Re: [GENERAL] Locale/encoding problem/question

2006-08-04 Thread Martijn van Oosterhout
On Fri, Aug 04, 2006 at 10:48:17AM +0200, [EMAIL PROTECTED] wrote: > Hello all, > > I somehow managed to stuff up the encoding (or locale or something) in a > transfer of a database from one machine to another (also different linux > distribution). > > The problem is this: the origional database

[GENERAL] Locale/encoding problem/question

2006-08-04 Thread henka
Hello all, I somehow managed to stuff up the encoding (or locale or something) in a transfer of a database from one machine to another (also different linux distribution). The problem is this: the origional database was created and populated with data using whatever default locale/encoding was i