On Thu, Sep 25, 2008 at 1:59 AM, Claus Guttesen <[EMAIL PROTECTED]> wrote: > Hi. > > I found out by accident that my db-dump, at least in ver. 8.3.3, > automagically converts from iso-8859-1 to utf-8. Our db has been > around since January 2000 and iso-8859-1 was chosen back then as > encoding. When I occasionally imported the nightly dump to a test-db > it would complain very early during the import and abort if the > encoding was incorrect. I think this was also the case with 8.3.1 > although I'm not certain.
I'm guessing that the client encoding is set to utf-8 instead of iso-8859-1 on the client end. pg automatically converts to the client encoding of the user connecting / environment. I know that at least 8.2 supports the -E switch to set client encoding. psql --help MUCH SNIPPED: -E, --encoding=ENCODING dump the data in encoding ENCODING -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
