Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error

Поиск
Список
Период
Сортировка
От Soeren Laursen
Тема Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error
Дата
Msg-id 3F08B840.14696.2D891A9@localhost
обсуждение исходный текст
Ответ на Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore  (Markus Bertheau <twanger@bluetwanger.de>)
Ответы Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore  (Markus Bertheau <twanger@bluetwanger.de>)
Список pgsql-admin
Hi,

I am not sure how and where I should use the \encoding latin1

Something like,

psql test01
\encodinng latin1
\q

pg_restore .....

Regards

Søren,

> В Вск, 06.07.2003, в 19:57, Soeren Laursen пишет:
>
> > pg_restore: ERROR:  copy: line 1, Invalid UNICODE character sequence
> > found (0xf87665)
>
> > No need to say that the new database is created with UNICODE
> > encoding?!
>
> use
>
> \encoding latin1
>
> once when you import the data. That'll convert the data from latin1 to
> utf-8 encoded unicode on the fly. Then again I don't know what charset
> denmark uses usually, probably some other latin variant.
>
> --
> Markus Bertheau.
> Berlin, Berlin.
> Germany.



В списке pgsql-admin по дате отправления:

Предыдущее
От: Markus Bertheau
Дата:
Сообщение: Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore
Следующее
От: aromero@dia.uned.es
Дата:
Сообщение: Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2