pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
HowTo change encoding type....
2+ messages / 2 participants
[nested] [flat]

* HowTo change encoding type....
@ 2004-11-25 18:43 Andrew M <andrew@jibeya.com>
  2004-11-26 07:30 ` Re: HowTo change encoding type.... Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Andrew M @ 2004-11-25 18:43 UTC (permalink / raw)
  To: pgsql-sql

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


many thanks


Andrew

 +The home of urban music
  + http://www.beyarecords.com

Attachments:

beya-email.gif (image/gif, 3.5K) download view image
^ permalink raw reply [nested|flat] 2+ messages in thread

* Re: HowTo change encoding type....
  2004-11-25 18:43 HowTo change encoding type.... Andrew M <andrew@jibeya.com>
@ 2004-11-26 07:30 ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2004-11-26 07:30 UTC (permalink / raw)
  To: Andrew M <andrew@jibeya.com>; +Cc: pgsql-sql

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/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-11-26 07:30 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-25 18:43 HowTo change encoding type.... Andrew M <andrew@jibeya.com>
2004-11-26 07:30 ` Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox