Postgres Pro
Downloads
Home   >   mailing lists

Re: Encoding errors when upgrading from 7.4 to 8.1 - Mailing list pgsql-general

From Seneca Cunningham
Subject Re: Encoding errors when upgrading from 7.4 to 8.1
Date
Msg-id 43D911D2.9000700@ca.afilias.info
Whole thread Raw
In response to Encoding errors when upgrading from 7.4 to 8.1  (Adam Witney <awitney@sgul.ac.uk>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Suggestions on storing and retrieving geocode data
Next
From: Bob Pawley
Date:
Subject: Arrays