Thank you all for your thoughtful suggestions. I just left for a 5 day East Coast business trip so I won't have a chance to tackle this gain until the weekend. For the record, I am running Centos as a VM on both a MAC OS 10.7 laptop and a Windows 7 Workstation. In theory, I ought to be able use these differing platforms to test these suggestions more rigorously. Thanks again! Hagen Finley hagen.finley@xxxxxxx Technical Business Consultant EMC 303-886-1232 Sent from my iPad 2 On Jan 3, 2012, at 3:34, John R Pierce <pierce@xxxxxxxxxxxx> wrote: > On 01/02/12 6:21 PM, Hagen Finley wrote: >> Yes but I couldn't input your second line - the ('ä,ß,ö') was not possible via the psql client - just got beeped when I tried to type or paste those characters. > > the problem is, MS Windows and only MS Windows uses UTF16 instead of the UTF8 that the entire rest of the world uses, so what looks right in Notepad or other windows software, is in fact encoded wrong for any non-MS UTF8 system. your SSH utility is supposed to be taking care of the differences, and it generally works with VanDyke's SecureCRT but I've had issues with PuTTY. > > -- > john r pierce N 37, W 122 > santa cruz ca mid-left coast > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general