On 2012-01-03, Frank Lanitz fr...@frank.uvena.de wrote:
Am 02.01.2012 20:13, schrieb Hagen Finley:
I am using psql (8.2.15) and I would like to input German characters
(e.g. ä,ß,ö) into char fields I have in a database
I see that you are using Outlook which leads me to assume you are
running
I wonder if the issue is in client encoding. How do these characters
in various Windows codepages relate to UTF characters?
Best Wishes,
Chris Travers
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
* Hagen Finley:
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.
If you start cat instead of psql, can you enter those characters?
What about python or the shell itself? What
Am 02.01.2012 20:13, schrieb Hagen Finley:
I am using psql (8.2.15) and I would like to input German characters
(e.g. ä,ß,ö) into char fields I have in a database
I see that you are using Outlook which leads me to assume you are
running Windows as host for your transaction. Therefor you might
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
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
Hi,
I am using psql (8.2.15) and I would like to input German characters (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
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.
want?
Hagen
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@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
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
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
On Monday, January 02, 2012 12:25:26 pm Hagen Finley wrote:
Thanks Adrian,
Looks like I am currently using UTF8:
gpdemo=# \encoding
UTF8
Well that shows the client encoding not the server encoding.
For that either do
\l
or
show server_encoding;
And it looks like UTF8
-general@postgresql.org
Cc: finha...@comcast.net
Subject: Re: [GENERAL] Adding German Character Set to PostgresSQL
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
On Monday, January 02, 2012 1:47:13 pm Hagen Finley wrote:
Hannes,
The output of \l is:
gpdemo=# \l
List of databases
Name| Owner | Encoding | Access privileges
+-+--+-
acn| gpadmin | UTF8
Hi Hagen,
gpdemo | gpadmin | UTF8 |
that UTF8 ought to support the German characters I want.
Am I understanding you correctly?
Yes, UTF-8 supports all the characters you'd want -- Wikipedia says it's
about 109.000 characters from 93 scripts, so that's pretty everything
you might
@postgresql.org
Cc: Hagen Finley; 'Hannes Erven'
Subject: Re: [GENERAL] Adding German Character Set to PostgresSQL
On Monday, January 02, 2012 1:47:13 pm Hagen Finley wrote:
Hannes,
The output of \l is:
gpdemo=# \l
List of databases
Name| Owner | Encoding
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
@postgresql.org
Subject: Re: [GENERAL] 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
On Monday, January 02, 2012 4:37:18 pm Hagen Finley wrote:
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.
So to be clear did you try?:
create table x(a text);
insert into x values('ä,ß,ö');
SELECT *
Finley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Adding German Character Set to PostgresSQL
On Monday, January 02, 2012 4:37:18 pm Hagen Finley wrote:
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
On Monday, January 02, 2012 6:21:53 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.
Hmmm.
Have you checked what client_encoding is set to in postgresql.conf
Hi Hagen,
all german umlaut characters works fine in postgres from my experience.
Seems you have encoding issues between windows tools/console/db-client.
Use a utf8 capable client. Any java tool or pgadmin or similar are fine.
regards
Thomas
Am 02.01.2012 20:13, schrieb Hagen Finley:
Hi,
22 matches
Mail list logo