Re: German special characters Problem

Someone else will have to tell you this. Or, you can look up 'initdb' in
the manuals or at:

    http://marc.theaimsgroup.com/ (under databases/postgresql)

I am mostly a user at this point, but I've seen your problem mentioned
and I replied with what I've seen is usually the problem.

Amin Schoeib wrote:

>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>