Character encoding in database dumps

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?

Thanks,

Lynna

--
Resource Centre Database Coordinator
Gallery 44
www.gallery44.org