Обсуждение: German special characters Problem
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
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'
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'
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
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
>
>
>
On Tuesday 09 September 2003 16:10, Dennis Gearon wrote: > 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_ > Check here: http://www.postgresql.org/docs/7.3/interactive/multibyte.html#AEN21737 Regards !