Thread: HowTo change encoding type....

HowTo change encoding type....

From
Andrew M
Date:
<fixed><x-tad-bigger>Hi,

how do I change the encoding type in postgreSQL (8) from UTF-8 to
ISO-8859-1?



many thanks



Andrew</x-tad-bigger></fixed>

Hi,
how do I change the encoding type in postgreSQL (8) from UTF-8 to
ISO-8859-1?


many thanks


Andrew


<bold><fontfamily><param>Arial</param><color><param>8080,0000,0000</param><smaller> +The
home of urban music

 + http://www.beyarecords.com

</smaller></color></fontfamily></bold>
 +The home of urban music
  + http://www.beyarecords.com

Attachment

Re: HowTo change encoding type....

From
Peter Eisentraut
Date:
Andrew M wrote:
> how do I change the encoding type in postgreSQL (8) from UTF-8 to
> ISO-8859-1?

Dump your database, drop your database, recreate your database with the 
different encoding, reload your data.  Make sure the client encoding is 
set correctly during all this.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/