Encoding errors when upgrading from 7.4 to 8.1

From: Adam Witney <awitney(at)sgul(dot)ac(dot)uk>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Encoding errors when upgrading from 7.4 to 8.1
Date: 2006-01-26 18:07:45
Message-ID: BFFEC071.56592%awitney@sgul.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am upgrading from 7.4.8 -> 8.1.2 on Linux 2.6.14.3 #1 SMP

I have installed 8.1.2 and created the database (with encoding 'UNICODE', as
I had done in 7.4.8) and am trying to load a 7.4.8 dump file but I am
getting a few errors like this:

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?

Thanks for any help

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-01-26 18:12:21 Re: Suggestions on storing and retrieving geocode data
Previous Message Tom Lane 2006-01-26 18:04:53 Re: [HACKERS] [PATCH] Better way to check for getaddrinfo