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:
http://www.postgresql.org/mailpref/p
On 2012-01-03, Frank Lanitz 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 Windows as h
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
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 en
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
* 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? Wha
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,
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.con
54 PM
To: Hagen 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
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
neral@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
>
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
~]$
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Monday, January 02, 2012 2:59 PM
To: pgsql-general@postgresql.org
Cc: Hagen Finley; 'Hannes Erven'
Subject: Re: [GENERAL] Adding German Character Set to PostgresSQL
On Monday, January 0
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 migh
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 |
pgsql-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 we
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 lo
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
ser
ssage-
> 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 Finley
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
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.
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 separa
22 matches
Mail list logo
