Skip site navigation (1) Skip section navigation (2)

Re: db encoding

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 (view raw or flat)
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

In response to

  • db encoding at 2009-01-05 16:36:42 from Oliveiros Cristina

pgsql-novice by date

Next:From: JORGE MALDONADODate: 2009-01-05 22:44:16
Subject: VARCHAR AND TEXT DATA TYPES
Previous:From: Oliveiros CristinaDate: 2009-01-05 16:36:42
Subject: db encoding

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group