Hi Gunnar,
"Gunnar Groetschel" <ggroetschel@sokoma.de> writes:
> I have tried all "SET CLIENT_ENCODING TO '*'" but nothin worked.
Well, this has definitly an effect here in my installation with
SERVER_ENCODING=UNICODE. It's possible though, that PostgreSQL treats
a conversion from SERVER_ENCODING=SQL_ASCII to CLIENT_ENCODING=LATIN1
or any other encoding as a no-op, which is not surprising. Try to
setup your database as UNICODE or LATIN1 and see if SET
CLIENT_ENCODING works than.
> I have set up the debugging and PGAdmin says that it is using the
> SQL_ASCII encoding. All the Umlauts are there. This is really
> curious.
To repeat: "ASCII" means "there are no umlauts, and if you insist on
putting random 8-bit characters into the database, you are on your
own." There is nothing curious about that this works in some
applications and doesn't work in others. Unless I am missing
something here.
benny