Postgres Pro
Downloads
Home   >   mailing lists

Re: Invalid byte sequence for encoding "UTF8" - Mailing list pgsql-novice

From John DeSoi
Subject Re: Invalid byte sequence for encoding "UTF8"
Date
Msg-id BF0BAA5A-F2FC-4A3D-A2AC-139FE22204BE@pgedit.com
Whole thread Raw
In response to Invalid byte sequence for encoding "UTF8"  ("Neil Saunders" <n.j.saunders@gmail.com>)
Responses Re: Invalid byte sequence for encoding "UTF8"  ("Neil Saunders" <n.j.saunders@gmail.com>)
List pgsql-novice
Tree view 
You'll probably need to dump the database as SQL_ASCII (in text
format) and then use a program like iconv (http://en.wikipedia.org/
wiki/Iconv) to fix it so that it is valid UTF8.


On May 14, 2007, at 5:23 PM, Neil Saunders wrote:

> I'm at temping to migrate a database from a Windows installation
> (8.1.4) to a Linux installation (8.2.4). I've successfully migrated
> the schema, but now am running in to difficulties importing the data.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

pgsql-novice by date:

Previous
From: "Neil Saunders"
Date:
Subject: Invalid byte sequence for encoding "UTF8"
Next
From: Raimon Fernandez
Date:
Subject: how to retrieve table definition