postgres & server encodings

From: "Salem Berhanu" <salemb4(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: postgres & server encodings
Date: 2005-08-08 16:10:50
Message-ID: BAY103-F36DC25F51006C5179B29E0EFB80@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin 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. ??}

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mario Soto Cordones - Venezuela 2005-08-08 16:24:14 Re: [GENERAL] postgresql Secure Mode
Previous Message Alvaro Herrera 2005-08-08 16:08:44 Re: [GENERAL] postgresql Secure Mode

Browse pgsql-general by date

  From Date Subject
Next Message Mario Soto Cordones - Venezuela 2005-08-08 16:24:14 Re: [GENERAL] postgresql Secure Mode
Previous Message Alvaro Herrera 2005-08-08 16:08:44 Re: [GENERAL] postgresql Secure Mode