Re: German special characters Problem

Is it possible to change the encoding on a existing
Database?

I mda this:

psql -l
List of databases
Name | Owner | Encoding
-----------+-------+-----------
test | pgsql | SQL_ASCII
(1 rows)

I think for german and other european languages I must use UNICODE
But how can I change the encoding on the existing database 'test'

-----Ursprüngliche Nachricht-----
Von: Amin Schoeib
Gesendet: Dienstag, 9. September 2003 16:13
An: Dennis Gearon
Cc: pgsql-general(at)postgresql(dot)org
Betreff: Re: [GENERAL] German special characters Problem

So what can I do that I don't get wrong characters???

-----Ursprüngliche Nachricht-----
Von: Dennis Gearon [mailto:gearond(at)fireserve(dot)net]
Gesendet: Dienstag, 9. September 2003 16:11
An: Amin Schoeib
Cc: pgsql-general(at)postgresql(dot)org
Betreff: Re: [GENERAL] German special characters Problem

Amin Schoeib wrote:

> Hi,
> Can somebody tell me why german special characters like 'ü' or 'ä'
> will be changed To '?' when retrieving data from postgres with Java
> (JDBC). When I select the data under
> Postgres everything is ok. The problem occurs when I select the data
> with Java.
>
> ???
>
> Hope somebody can helps.
>
> 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_
>
It can be anywhere in the datastream where the encodings don' tmatch.
Usually it's how the database was 'initdb'

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend