| 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: | Whole Thread | Raw Message | 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.
| 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 |