Search Postgresql Archives

Re: Adding German Character Set to PostgresSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx]
Sent: Monday, January 02, 2012 12:40 PM
To: Hagen Finley
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: 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@xxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux