Re: Encoding errors when upgrading from 7.4 to 8.1

Поиск
Список
Период
Сортировка
От Seneca Cunningham
Тема Re: Encoding errors when upgrading from 7.4 to 8.1
Дата
Msg-id 43D911D2.9000700@ca.afilias.info
обсуждение исходный текст
Ответ на Encoding errors when upgrading from 7.4 to 8.1  (Adam Witney <awitney@sgul.ac.uk>)
Список pgsql-general
Adam Witney wrote:
> psql:bugasbase2-backup:45880: ERROR:  invalid UTF-8 byte sequence detected
> near byte 0xb5
> CONTEXT:  COPY array_scheme, line 17560, column gene_identifier: "B?G@S
> (0G11)"
>
> This dump file will load error free into 7.4.8.
>
> Does anybody have any ideas why this is failing in 8.1.2?

8.1 changed UTF-8 handling to be more strict about invalid sequences.
You may want to read the 8.1.0 release notes.

<http://www.postgresql.org/docs/8.1/interactive/release-8-1.html>

--
Seneca Cunningham
scunning@ca.afilias.info

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Suggestions on storing and retrieving geocode data
Следующее
От: Bob Pawley
Дата:
Сообщение: Arrays