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'

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:

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 !