Re: Adding German Character Set to PostgresSQL

From: Hannes Erven <hannes(at)erven(dot)at>
To: pgsql-general(at)postgresql(dot)org
Cc: finhagen(at)comcast(dot)net
Subject: Re: Adding German Character Set to PostgresSQL
Date: 2012-01-02 20:52:34
Message-ID: 4F021912.4020602@erven.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hagen,

> gpdemo=# \encoding
> UTF8

UTF8 includes virtually all characters you will need for any purpose on
the earth.

But: you showed the output of \encoding when you were asked to show \l .

There is a subtle difference:
\encoding shows the encoding of the connection between psql and the
server; while
\l shows the encoding the database server will actually store the data in.

While the first can easily be changed for a session, the latter can only
be set when creating a database (or a cluster).

-hannes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-01-02 20:53:08 Re: Adding German Character Set to PostgresSQL
Previous Message Pavel Stehule 2012-01-02 20:30:59 Re: Adding German Character Set to PostgresSQL