Yes I am running psql on Centos. My psql client won't accept the German characters whether or not I attempt to type them or paste them. -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] Sent: Monday, January 02, 2012 5:05 PM To: Hagen Finley Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Adding German Character Set to PostgresSQL On Monday, January 02, 2012 3:41:40 pm Hagen Finley wrote: > As you indicated UTF-8 has the whole kitchen sink in it. I did trying > using the German Keyboard Layout with a Centos text editor and that > works - I can produce the characters I want. Now I can also get the > German characters to work in the Centos terminal but not in the psql > command line client. Progress but still no joy. So you are using psql on the Centos machine? I have the same locale as you, on my Linux machine, and using Pavels example I get: test(5432)aklaver=>create table x(a text); CREATE TABLE test(5432)aklaver=>insert into x values('ä,ß,ö'); INSERT 0 1 test(5432)aklaver=>SELECT * from x ; a ------- ä,ß,ö (1 row) What happens when you do the above on your machine? > -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
