Skip site navigation (1) Skip section navigation (2)

Re: Invalid byte sequence for encoding "UTF8"

From: "Neil Saunders" <n(dot)j(dot)saunders(at)gmail(dot)com>
To: "John DeSoi" <desoi(at)pgedit(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Invalid byte sequence for encoding "UTF8"
Date: 2007-05-15 21:51:34
Message-ID: ddcd549e0705151451x6b5cc1f6s929cf00b6d9c1a2a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Excellent - Thanks John - I'll give that a crack.

Any idea why the --encoding flag didn't do this via pg_dump?

Thanks again,

Neil.

On 5/15/07, John DeSoi <desoi(at)pgedit(dot)com> wrote:
> 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

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2007-05-15 21:59:52
Subject: Re: aggregate function ?
Previous:From: Raimon FernandezDate: 2007-05-15 20:56:37
Subject: aggregate function ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group