Thanks Adrian,
Looks like I am currently using UTF8:
gpdemo=# \encoding
UTF8
And it looks like UTF8 doesn’t include the German characters I seek. Can someone explain how I can switch to 0000-0FFF which looks like the Basic Multilingual Plane Unicode which does include the characters I want?
Hagen
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@gmail.com]
Sent: Monday, January 02, 2012 12:40 PM
To: Hagen Finley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Adding German Character Set to PostgresSQL
On 01/02/2012 11:13 AM, Hagen Finley wrote:
> Hi,
>
> I am using psql (8.2.15) and I would like to input German characters
I am going to assume you are using a Postgresql 8.2.15 server(psql is the client program for Postgres, I am being pedantic because it reduces the confusion level:) )
> (e.g. ä,ß,ö) into char fields I have in a database. I am having
> trouble getting the CENTOS Linux OS I am using to input German
> characters via a (apparently supported) German Keyboard Layout.
> However, that might be a separate matter. When I typed the German into
> Notepad in Windows and attempted to cut and paste the words into an
> INSERT statement, the characters do not persist:
Not sure it would help, but if I had a choice I would use Wordpad.
Notepad tends to fairly brain-dead when handling text.
>
> Daß becomes DaDa and Heißt becomes HeiHeit which falls short of what I
> was hoping for.
>
> I am wondering if I need to enable an international character set
> within Postgres before the German characters will input properly? If
> so, it’s not clear from the documentation I have attempted to find how
> one enables other characters sets within Postgres? Any suggestions
> will be much appreciated. Thank you.
Using psql do a \l at the prompt. That will show what encoding the database was setup with.
>
> Hagen Finley
>
> Boulder, CO
>
Thanks,
--
Adrian Klaver
adrian.klaver@gmail.com