BUG #2804: Incorrect encoding of comment in backup of UTF8 database

From: "Marcin Waldowski" <M(dot)Waldowski(at)sulechow(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2804: Incorrect encoding of comment in backup of UTF8 database
Date: 2006-12-02 12:45:26
Message-ID: 200612021245.kB2CjQf4067751@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2804
Logged by: Marcin Waldowski
Email address: M(dot)Waldowski(at)sulechow(dot)net
PostgreSQL version: 8.1.5
Operating system: Windows XP SP2 (polish version)
Description: Incorrect encoding of comment in backup of UTF8 database
Details:

When I make a backup of UTF8 database then pg_dump add some comment to
backup file:

-- Started on 2006-11-30 16:01:15 srodkowoeuropejski czas stand.

'Srodkowoeuropejski czas stand.' means in polish 'centraleuropean standard
time'. Unfortunately first letter of 'srodkowoeuropejski' is our national
letter which is similar to 's' and it is encoded incorretly in UTF8. It
makes following error during restore:

pg_restore: connecting to database for restore

pg_restore: [archiver (db)] Error while INITIALIZING:

pg_restore: [archiver (db)] could not execute query: ERROR: invalid byte
sequence for encoding "UTF8": 0x8c

HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".

Command was:--

-- PostgreSQL database dump

--

-- Started on 2006-11-30 16:01:15 srodkowoeuropejski czas stand.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-12-02 16:36:30 Re: BUG #2804: Incorrect encoding of comment in backup of UTF8 database
Previous Message asp techie 2006-12-02 12:16:16 'PostgreSQL.1' failed with no error message available, result code: -2147221163(0x80040155).