postgres & server encodings - Mailing list pgsql-general

From Salem Berhanu
Subject postgres & server encodings
Date
Msg-id BAY103-F36DC25F51006C5179B29E0EFB80@phx.gbl
Whole thread Raw
Responses Re: postgres & server encodings  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: postgres & server encodings  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
What exactly is the SQL_ASCII encoding in postgres? I have a pg installation
with an SQL_ASCII server encoding and my database (also SQL_ASCII) seems to
be able to handle all types of encodings? how is this possible? is this what
the server & db encoding needs to be set to in order to handle various
encodings?
Also is there a way of dumping data from an SQL_ASCII db to a UNICODE db.
Creating a dump and converting with a tool like iconv is probably not an
option since the data in the SQL_ASCII db has unknown/inconsistant encoding.
Please let me know as soon as possible.
Thanks.
Salem
P.S. {I sent a similar e-mail earlier which wasn't posted on the site. ??}


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Case sensitivity
Next
From: Ben-Nes Yonatan
Date:
Subject: Re: Weird lock or bug maybe?