"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
In response to
- db encoding at 2009-01-05 16:36:42 from Oliveiros Cristina
pgsql-novice by date
|Next:||From: JORGE MALDONADO||Date: 2009-01-05 22:44:16|
|Subject: VARCHAR AND TEXT DATA TYPES|
|Previous:||From: Oliveiros Cristina||Date: 2009-01-05 16:36:42|
|Subject: db encoding|