Re: Encoding errors when upgrading from 7.4 to 8.1

From: Seneca Cunningham <scunning(at)ca(dot)afilias(dot)info>
To: Adam Witney <awitney(at)sgul(dot)ac(dot)uk>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Encoding errors when upgrading from 7.4 to 8.1
Date: 2006-01-26 18:15:46
Message-ID: 43D911D2.9000700@ca.afilias.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)ca(dot)afilias(dot)info

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2006-01-26 18:20:50 How to implement nested transactions
Previous Message Bob Pawley 2006-01-26 18:15:22 Arrays