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

Re: Character encoding in database dumps

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Lynna Landstreet <lynna(at)gallery44(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Character encoding in database dumps
Date: 2004-06-10 17:51:21
Message-ID: 1086889881.2758.1.camel@teetnang (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
В Срд, 09.06.2004, в 20:11, Lynna Landstreet пишет:
> Hi there,
> My database was created with Unicode encoding, as a fair number of the
> artists and exhibitions have French names, and thus include accented
> characters. I thought I'd solved all the various problems this generates,
> but have just discovered one new one.
> When I do a dump of the database to back it up (because I'm paranoid and
> don't want my web host to be my only source of security on this matter), the
> accented characters don't come through correctly. They all display correctly
> in phpPgAdmin, and in the PHP pages I've made to search and display the data
> - it's just in dumps that they're garbled. I presume this means the Unicode
> encoding is somehow being lost and the data read as standard ASCII.
> I'm currently using phpPgAdmin to export the data, and it gives me a choice
> of downloading it as a .sql file or displaying it in the browser window, but
> either way, the special characters are toasted. Does anyone have any idea
> how I can do a database dump that keeps the character encoding intact?

How do you determine that the character encoding is wrong? Maybe
whatever it is you use to look at the dump just doesn't interpret the
data as UTF-8.

Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

pgsql-novice by date

Next:From: Eduardo V. RodríguezDate: 2004-06-10 22:35:28
Subject: Size of a table
Previous:From: Eduardo V. RodríguezDate: 2004-06-10 17:15:37
Subject: Re: Help with JSP connection with postgreSQL

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