v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8 - Mailing list pgsql-general

From Ralph Smith
Subject v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8
Date
Msg-id 01D6A67B-E4CC-4D6C-A36A-8FE17AC22951@washington.edu
Whole thread Raw
Responses Re: v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8
List pgsql-general
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



pgsql-general by date:

Previous
From: "D. Dante Lorenso"
Date:
Subject: Cascading Trigger - changing row on delete does not delete row
Next
From: "hernan gonzalez"
Date:
Subject: Re: text and bytea