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@postgresql.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@fireserve.net]
Gesendet: Dienstag, 9. September 2003 16:11
An: Amin Schoeib
Cc: pgsql-general@postgresql.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