Thread: [DUMP] Make a dump with special characters

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

 

2. 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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Leví Teodoro da Silva
Sent: Thursday, November 06, 2008 3:51 AM
To: pgsql-novice@postgresql.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