Re: Converting database-encoding from SQL_ASCII to UNICODE?????

I don't know if you can alter the encoding of an existing database.

But you can change the client encoding by:
set client_encoding to 'UNICODE'

> X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
> content-class: urn:content-classes:message
> Subject: [GENERAL] Converting database-encoding from SQL_ASCII to UNICODE?????
> Date: Fri, 12 Sep 2003 11:54:40 +0200
> X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0
> X-MS-Has-Attach:
> X-MS-TNEF-Correlator:
> Thread-Topic: Converting database-encoding from SQL_ASCII to UNICODE?????
> Thread-Index: AcN5E+KXB8tDpbN5TjmKLpvEOc40LA==
> From: "Amin Schoeib" <aschoeib(at)4tek(dot)de>
> To: <pgsql-general(at)postgresql(dot)org>
> X-Virus-Scanned: by amavisd-new at postgresql.org
> X-Mailing-List: pgsql-general
>
> Hi,
> I have a database with encoding SQL_ASCII.
> Now I need to convert the encoding to UNICODE.
> Can somebody tell me how I can do that????
>
> Thanxx
>
> Schoeib
>
> 4Tek Gesellschaft für angewandte Informationstechnologien mbH
> Schoeib Amin
> Tel. +49 (0) 69 697688-132
> Fax. +49 (0) 69 697688-111
> http://www.4tek.de
>