Thread: [DUMP] Make a dump with special characters

[DUMP] Make a dump with special characters

From
"Leví Teodoro da Silva"
Date:
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


Re: [DUMP] Make a dump with special characters

From
"Leví Teodoro da Silva"
Date:
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@esri.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@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