Hello, I've been happily developing using postgres with pgadmin3 (1.16.0 on Windows) for a while now, and using the Backup pg_dump GUI plugin successfully. My database (with everything set to use UTF8) has gotten bigger, and today when I did my backup I saw unicode characters output incorrectly (examples: µ output as µ and – output as –). I experimented with what might be different, and the only thing I can see that's different is amount of data (or tables). Using the exact same settings otherwise:
- If I export just two smallish tables with unicode chars, they appear correctly - If I export all 64 tables (~9.4MB), including the two with unicode chars, they are output with the wrong encoding. The commands appear to be identical in the Message tab of the Backup GUI, so it seems like something wrong at the pg_dump level. pg_dump command output by Backup GUI in both cases: C:\Program Files (x86)\pgAdmin III\1.16\pg_dump.exe --host 127.0.0.1 --port 8889 --username "<username>" --no-password --format plain --encoding UTF8 --inserts --file "<file path>" --table " " --table " " "<database name>" Any ideas? Thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/UTF8-issue-when-using-Backup-pg-dump-on-many-tables-tp5753342.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
