Re: Changing encoding of a database - Mailing list pgsql-general

From Marco Bizzarri
Subject Re: Changing encoding of a database
Date
Msg-id 3f0d61c40606210117t791d1fcfq6561d86b5cf162a4@mail.gmail.com
Whole thread Raw
In response to Changing encoding of a database  ("Marco Bizzarri" <marco.bizzarri@gmail.com>)
List pgsql-general
Hi Tomi.

Thanks for your answer, I was not aware of such a tool.

The next question at this point is (of course): what is the problem if
I have blob? Should I recode them as well?

Regards
Marco

On 6/20/06, Tomi NA <hefest@gmail.com> wrote:
> On 6/19/06, Marco Bizzarri <marco.bizzarri@gmail.com> wrote:
> > I all.
> >
> > We've PostgreSQL database, with SQL_ASCII or LATIN1 encoding. We would
> > like to migrate them to UNICODE. Is there some contributed/available
> > script, or this is something we should do at hand?
> >
> > Regards
> > Marco
>
> If you don't have blobs in your database, dump it to insert
> statements, use the recode tool to recode your data, create a new
> database based on UTF8 and load the data.
>
> t.n.a.
>


--
Marco Bizzarri
http://notenotturne.blogspot.com/

pgsql-general by date:

Previous
From: "Jad Madi"
Date:
Subject: unsubscribe
Next
From: "Gurjeet Singh"
Date:
Subject: Re: Computing transitive closure of a table