| 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 |