Date: Sat, 14 Jul 2001 05:20:50 +0200
From: Lars Bensmann <lars.bensmann@epost.de>
To: pgsql-interfaces@postgresql.org
Subject: Re: pgaccess - international characters
Message-ID: <20010714052050.B9290@epost.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20010713013221.A1515@epost.de>
User-Agent: Mutt/1.3.18i

Hello,

On Fri, Jul 13, 2001 at 01:32:22AM +0200, Lars Bensmann wrote:
> 
> Now we have several Windows workstations using pgaccess to enter data into
> several tables. Everything is fine when using forms. International
> characters (like the german umlaute) work fine. But when I open the table
> directly don't get human readable output for the characters. It varies
> from one or several blank characters to "garbage".

I tested this on another box with Debian unstable installed (this includes
PostgreSQL 7.1.2).

When I use psql to enter umlaut characters everything is fine. pg_dump and
gtksql show proper results. Even pgaccess displays the characters
correctly. But when I enter the characters in pgaccess or update a record
I entered with psql I get this "garbage" again.

I examined this a bit more closely and it seems that the characters are
translated like this:

"a: <C3><A4>
"o: <C3><B6>
"u: <C3><BC>
"A: <C3><84>
"O: <C3><96>
"U: <C3><9C>
"s: <C3><9F>

I get the same results when I enter the data using Tksql as suggested by
Sandro.

This seems to be related to tcl or tk. Am I the only one with this
problem? What can I do about this?

TIA,
Lars

-- 
Any time things appear to be going better, you have overlooked something.