Re: [DUMP] Make a dump with special characters

Hi Kasia,

Thanks a lot for the information, i got some misconfigurations on the
server, now i dit it and the dump is working correctly.

Thanks,
Leví

2008/11/6 Kasia Tuszynska <ktuszynska(at)esri(dot)com>

> Hi Levi,
>
> I would say that it is not the dumping process that is creating a problem;
> it is probably the restoring process that is generating the error.
>
> Your issue can fall into two categories, as far as I can tell:
>
> 1. The postgres cluster encoding, the server encoding and the client
> encoding are not set properly. The postgres help gives good guidance on how
> to set up a combination of the three
>
>
>
> 1. You are running into an issue that other folks ( including myself)
> have run into with the german umlaut characters on the following
> configuration:
> 1. Cluster encoding: C
> 2. Server encoding: UTF8
> 3. Client encoding: UTF8
>
> Where the umlaut character is stored as two characters: and postgres does
> not successfully read the two characters as one
>
>
>
> Sincerely,
>
> Kasia
> ------------------------------
>
> *From:* pgsql-novice-owner(at)postgresql(dot)org [mailto:
> pgsql-novice-owner(at)postgresql(dot)org] *On Behalf Of *Leví Teodoro da Silva
> *Sent:* Thursday, November 06, 2008 3:51 AM
> *To:* pgsql-novice(at)postgresql(dot)org
> *Subject:* [NOVICE] [DUMP] Make a dump with special characters
>
>
>
> Hi guys !!!!
>
> I am from Brazil, and here we use a lot of special characters like : ã, é.
> I did a dump from my database, and when i will restore the database i got
> error with the encoding : invalid byte sequence for encoding "UTF8":
> 0xf3706f6c
>
> I want to know if somebody, knows how can i do a dump that preserves my
> special characters !?
>
>
> Thanks,
> Levi
>
>