Hello,
I have some databases that are designated as SQL_ASCII encoding. I
need them to be UTF-8. I know that SQL_ASCII is really the
absence of encoding. Is there a way to do this?
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
Hi Carol
On Tue, Nov 18, 2008 at 4:06 PM, Carol Walter [EMAIL PROTECTED] wrote:
Hello,
I have some databases that are designated as SQL_ASCII encoding. I need
them to be UTF-8. I know that SQL_ASCII is really the absence of
encoding. Is there a way to do this?
Try use pg_dump on your
Hello,
I have some databases that use SQL ASCII or Latin1 encoding that need
to be UTF8. When I have drop the database and recreated it with the
correct encoding I get errors in restoring the data. How is this done?
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
I'm at 8.2.3
I do a data only pg_dump. I drop the database, then recreate it with
the correct encoding. Then load the data back in with psql.
Carol
On Jul 15, 2008, at 11:04 AM, Peter Eisentraut wrote:
Am Dienstag, 15. Juli 2008 schrieb Carol Walter:
I have some databases that use SQL
For the SQL_ASCII tables it depends what was actually written to the tables.
SQL_ASCII means that the server does not do any conversation and that the
client is responsible for the used encoding. So if there is data in the table
with different encodings (comming from different clients with
Am Dienstag, 15. Juli 2008 schrieb Carol Walter:
I have some databases that use SQL ASCII or Latin1 encoding that need
to be UTF8. When I have drop the database and recreated it with the
correct encoding I get errors in restoring the data. How is this done?
What is your PostgreSQL version?