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

Started by Amin Schoeibover 22 years ago2 messagesgeneral
Jump to latest
#1Amin Schoeib
aschoeib@4tek.de

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

#2Kathy Zhu
Kathy.Zhu@Sun.COM
In reply to: Amin Schoeib (#1)
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'

Show quoted text

X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.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@4tek.de>
To: <pgsql-general@postgresql.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