Re: [GENERAL] Questions about encoding between two databases

2009-08-21 Thread Archibald Zimonyi
encoding. Thanks for the tips. Archie Archibald Zimonyi wrote: Hello, Archibald Zimonyi writes: I went into the generated dump file and (more wish then anything else) tried to simply change the encoding from LATIN1 to UTF8 and then load the file, it did not complain about incorrect encoding

Re: [GENERAL] Questions about encoding between two databases

2009-08-21 Thread Archibald Zimonyi
Hello, Archibald Zimonyi writes: I went into the generated dump file and (more wish then anything else) tried to simply change the encoding from LATIN1 to UTF8 and then load the file, it did not complain about incorrect encoding setting for the load, however it complained that the characters

Re: [GENERAL] Questions about encoding between two databases

2009-08-21 Thread Archibald Zimonyi
setting for the load, however it complained that the characters did not match true UTF8 characters (which was almost what I guessed would happen). So back to square one again. Archie On Fri, 21 Aug 2009, Adrian Klaver wrote: On Thursday 20 August 2009 11:45:30 pm Archibald Zimonyi wrote

Re: [GENERAL] Questions about encoding between two databases

2009-08-21 Thread Archibald Zimonyi
On Fri, 21 Aug 2009, Adrian Klaver wrote: On Thursday 20 August 2009 11:45:30 pm Archibald Zimonyi wrote: Hello, I am sitting on version 7.4.x and am going to upgrade to version 8.3.x. From all I can read I should have no problem with actual format of the pgdump file (for actual dumping and

[GENERAL] Questions about encoding between two databases

2009-08-21 Thread Archibald Zimonyi
Hello, I am sitting on version 7.4.x and am going to upgrade to version 8.3.x. From all I can read I should have no problem with actual format of the pgdump file (for actual dumping and restoring purposes) but I am having problems with encoding (which I was fairly sure I would). I have searc