Re: Migration error " invalid byte sequence for encoding "UTF8": 0xff " from mysql 5.5 to postgresql 9.1

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Migration error " invalid byte sequence for encoding "UTF8": 0xff " from mysql 5.5 to postgresql 9.1
Дата
Msg-id 1404220708.34556.YahooMailNeo@web122301.mail.ne1.yahoo.com
обсуждение исходный текст
Ответ на Migration error " invalid byte sequence for encoding "UTF8": 0xff " from mysql 5.5 to postgresql 9.1  (sunpeng <bluevaley@gmail.com>)
Ответы Re: Migration error " invalid byte sequence for encoding "UTF8": 0xff " from mysql 5.5 to postgresql 9.1  (sunpeng <bluevaley@gmail.com>)
Список pgsql-general
sunpeng <bluevaley@gmail.com> wrote:

> load data to postgresql in cmd(encoding is GBK) is WIN8:

> psql -h localhost  -d test -U postgres <  dbdata.sql
>
> I got the error:
> ERROR:  invalid byte sequence for encoding "UTF8": 0xff

If the encoding is GBK then you will get errors (or incorrect
characters) if it is read as UTF8.  Try setting the environment
variable PGCLIENTENCODING.

http://www.postgresql.org/docs/9.1/static/app-psql.html

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: sunpeng
Дата:
Сообщение: Migration error " invalid byte sequence for encoding "UTF8": 0xff " from mysql 5.5 to postgresql 9.1
Следующее
От: Jacob Bunk Nielsen
Дата:
Сообщение: Next steps in debugging database storage problems?