Skip site navigation (1) Skip section navigation (2)

Re: [DUMP] Make a dump with special characters

From: Leví Teodoro da Silva <tlevisilva(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [DUMP] Make a dump with special characters
Date: 2008-11-07 12:07:45
Message-ID: 4a74ba520811070407w517cea5bjc1f144bbb3550953@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
>
>

In response to

pgsql-novice by date

Next:From: Leví Teodoro da SilvaDate: 2008-11-07 13:21:05
Subject: [INSERT]Return a value
Previous:From: Tom LaneDate: 2008-11-06 17:50:22
Subject: Re: Database Views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group