importing from 8.0.3 unicode problem
От | Theodore Petrosky |
---|---|
Тема | importing from 8.0.3 unicode problem |
Дата | |
Msg-id | 20051030202300.21581.qmail@web33205.mail.mud.yahoo.com обсуждение исходный текст |
Ответы |
Re: importing from 8.0.3 unicode problem
|
Список | pgsql-bugs |
I don't know if this is a bug or my not understanding something. I installed 8.1beta4 on a machine (mac os x 10.4.2). I have my pg_dump file from my running 8.0.3 server in the office (os x 10.3.9). I created a cluster with: initdb --encoding-UNICODE /path/to/dir then createdb databasename psql databasename </path/to/pg_dump/file I get an error: ERROR: invalid UNICODE byte sequence detected near byte 0x8e CONTEXT: COPY ioinfo, line 177, column publication: "Elle D?cor" ERROR: invalid UNICODE byte sequence detected near byte 0xa5 CONTEXT: COPY jobinfo, line 523, column shortdescription: "RUSH! KA - White lace shirt this is the top of my pg_dump file: -- -- PostgreSQL database dump -- SET client_encoding = 'UNICODE'; SET check_function_bodies = false; SET client_min_messages = warning; this is the line in question... 972 SC1511 Elle Décor November '04 f I don't understand why I am having a problem importing this datadump. Ted __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
В списке pgsql-bugs по дате отправления: