Hi Hagen, > gpdemo | gpadmin | UTF8 | > that UTF8 ought to support the German characters I want. > Am I understanding you correctly? Yes, UTF-8 supports all the characters you'd want -- Wikipedia says it's about 109.000 characters from 93 scripts, so that's pretty everything you might need ( http://en.wikipedia.org/wiki/Unicode ). So as we have excluded the database storage and the psql connection, there seems to be only the terminal left as a suspect. Could you try using pgAdmin or any other non-console based tool to connect to the database in question? The plain text you first posted looked quite strange, repeating previous parts of the strings before the Umlauts -- usually, unsupported Umlauts show up rather as two characters, or cut off the rest of the word completely. My guess would be that the characters are correctly stored in the DB, and are just not displayed correctly within your terminal. But again, this is best verified when you connect directly to the DB. I don't know anything about terminals in CentOS, but have you tried setting the LANG variable? http://www.linuxreport.org/content/view/53/31/ Good luck :-) -hannes -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
