From: | "Moshe Ben-Shoham" <mosheb(at)nexperience(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Encoding problem using pg_dumpall |
Date: | 2009-01-29 11:50:11 |
Message-ID: | 75E4C42D37E6A74E9FB57C2E9F1300D60107073E@tiger.nexperience.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hi,
I have a database with encoding UTF-8 installed on Windows, and I try to
dump it using pg_dumpall, on the machine on which the database is
installed. I get the following error message:
C:\Program Files\PostgreSQL\8.3\bin>pg_dumpall -U admint >
c:\temp\dbdump.sql
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: character 0xd595 of encoding
"UTF8" has no equivalent in "WIN1252"
pg_dump: The command was: COPY public.cms_history_properties
(structure_id, propertydef_id, property_mapping_id,
property_mapping_type, property_value, publish_tag) TO stdout;
pg_dumpall: pg_dump failed on database "opencms", exiting
it probably means that some UTF-8 characters cannot be represented in
WIN1252 which is the encoding of the output file.
Is there any solution to this problem?
Thanks,
Moshe Ben Shoham.
The information contained in this message is proprietary to the sender, protected from disclosure, and may be privileged. The information is intended to be conveyed only to the designated recipient(s) of the message. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, use, distribution or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you.
************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2009-01-29 14:06:20 | Re: finding dev rpms |
Previous Message | Tom Lane | 2009-01-28 19:49:52 | Re: Strange query problem... |
From | Date | Subject | |
---|---|---|---|
Next Message | Harald Armin Massa | 2009-01-29 12:37:41 | updateable view: message |
Previous Message | Gregory Stark | 2009-01-29 11:39:30 | Re: Slow first query despite LIMIT and OFFSET clause |