Re: v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8

On 2008-02-22 17:57, Ralph Smith wrote:
> I'm looking at the v7.4 manuals and I don't see how to encode for
> importing into a v8 DB using UTF8.
>
> Maybe I'm making this hard on myself?
> The old DB is using SQL_ASCII.
> We'd like the new one to use UTF8.
>
> As development proceeds, I'm going to have to do this regularly, both
> the entire DB and by tables.
> If not for the encoding, I've got all that down, even automated.
>
> Thanks for any help!
> Ralph
>
> -------------------------------
> p.s.  Isn't there a 16 bit Unicode for postgreSQL?
>
> smithrn at u dot washington dot edu
>

There's nothing to do.  Dump the database in ASCII; create the new
database with a server_encoding of UTF-8; and import the data (which is
marked as having a client_encoding of SQL_ASCII).

ps: No.

--
Mail to my list address MUST be sent via the mailing list.
All other mail to my list address will bounce.