From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: db encoding |
Date: | 2009-01-05 18:12:10 |
Message-ID: | 23834.1231179130@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
"Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> writes:
> Once a database is created , is there any easy way to change its encoding?
Nope --- you have to dump and reload into a new database created with
the correct encoding setting.
> I have several created with SQL_ASCII encoding, which I now realize is
> an encoding not very recommendable.
The problem with SQL_ASCII is that you don't really know what encoding
you've got, so even "dump and reload" may not be enough --- you may have
to fix any encoding problems that are in the data now. I'd suggest
pg_dump into plain text format so you can massage the data easily.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | JORGE MALDONADO | 2009-01-05 22:44:16 | VARCHAR AND TEXT DATA TYPES |
Previous Message | Oliveiros Cristina | 2009-01-05 16:36:42 | db encoding |