Re: Invalid byte sequence for encoding "UTF8"

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Neil Saunders <n(dot)j(dot)saunders(at)gmail(dot)com>
Cc: pgsqlnovice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Invalid byte sequence for encoding "UTF8"
Date: 2007-05-15 12:23:34
Message-ID: BF0BAA5A-F2FC-4A3D-A2AC-139FE22204BE@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Raimon Fernandez 2007-05-15 12:28:53 how to retrieve table definition
Previous Message Neil Saunders 2007-05-14 21:23:04 Invalid byte sequence for encoding "UTF8"