[postgis-users] encoding and german umlaute

[Paragon Corporation]

You could also set the client encoding at the database level if setting it
in Manifold is not an option and all you clients expect latin1.  Although
that is slightly more invasive.

To set at the database level - do one of the following

1) In PgAdmin right click the database - go to variables tab
2) pick client_encoding and set value to latin1
---------------------------------------------
Or the SQL way
ALTER DATABASE somedatabase SET client_encoding=latin1; 

Hope that helps,
Regina

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Monday, July 28, 2008 1:08 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] encoding and german umlaute

Judging from the gook you're getting in your second example (two characters
for every hibit character) the database probably has the data encoded as
UTF-8.

- If your database encoding is UTF8 (use psql -l for a listing of
databases) then the problem is Manifolds fault... for some reason it's
receiving UTF8 but interpreting it as LATIN1.  If you can tell it to "set
client_encoding = latin1" somehow, that might help. Otherwise, complain to
them, they should set their client encoding correctly as part of their
interaction with the database.
- If your database encoding is SQL-ASCII then the problem is your fault...
you've loaded encoded data but not specified the encoding, so the software,
both PgSQL and Manifold, can't create a nice processing chain to ensure it
is rendered correctly. Correct renderings of your data can sometimes happen,
but only by chance. In this case, dump your data and restore it into a UTF8
database.

P.

On Mon, Jul 28, 2008 at 9:58 AM, gisworks <stefan.overkamp at gisworks.de>
wrote:
>
> Hi,
>
> I'm using postgresql and manifold GIS. With manifold 8.0.8 connecting 
> to my postgres-Database shows scrambled german Umlaute (ä, ö, ü, ß, 
> and so on) in text fields.
> Connecting with manifold 8.0.7 the text is shown correct like in pgadmin:
> "Fläche für die Landwirtschaft"
> Connecting with manifold 8.0.8 the text is shown as: "Fläche für die 
> Landwirtschaft"
>
> Maybe there is a solution on the postgres side. Are there any 
> tutorials on the setup of encoding to allow german umlaute?
> What configuration would german users use when installing postgresql
8.3.3:
> initdb locale, encoding ... ?
> Which encoding I have to use on database creation?
> What is setting client_encoding about?
>
> Thanks
>
> --
> View this message in context: 
> http://www.nabble.com/encoding-and-german-umlaute-tp18694836p18694836.
> html Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users