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 <[EMAIL PROTECTED]> 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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users