Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
BUG #2861: when backup UTF-8 database,pgdump add comments not encoded in UTF-8
- From: "goodsforyou" <goodsforyou(at)gmail(dot)com>
- To: pgsql-bugs(at)postgresql(dot)org
- Subject: BUG #2861: when backup UTF-8 database,pgdump add comments not encoded in UTF-8
- Date: Sat, 23 Dec 2006 03:53:46 GMT
The following bug has been logged online: Bug reference: 2861 Logged by: goodsforyou Email address: goodsforyou(at)gmail(dot)com PostgreSQL version: 8.2.0 win32 Operating system: Windows xp sp2 Simplified Chinese Version Description: when backup UTF-8 database,pgdump add comments not encoded in UTF-8 Details: When I make a backup of a UTF8 database then pg_dump add some comment to backup file: -- Started on 2006-12-23 11:04:38 ä¸å½æ åæ¶é´ ... ... -- Completed on 2006-12-23 11:04:40 ä¸å½æ åæ¶é´ 'ä¸å½æ åæ¶é´' means in English 'China standard time'. Unfortunately it is encoded incorretly in GBK, not in UTF-8. 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": 0xd6d0
- Follow-Ups:
- Prev by Date: BUG #2860: can't install the software
- Next by Date: BUG #2862: ERROR: failed to build any 7-way joins
- Previous by thread: BUG #2860: can't install the software
- Next by thread: Re: BUG #2861: when backup UTF-8 database,pgdump add comments not encoded in UTF-8
- Indexes: