Date: Fri, 13 Jul 2001 11:35:27 +0200
From: Sandro Dentella <sandro.dentella@tin.it>
To: pgsql-interfaces@postgresql.org
Subject: Re: pgaccess - international characters
Message-ID: <20010713113527.A453@bluff.diade.it>
Mail-Followup-To: pgsql-interfaces@postgresql.org
References: <20010713013221.A1515@epost.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <20010713013221.A1515@epost.de>;
	from lars.bensmann@epost.de on Fri, Jul 13, 2001 at 01:32:22AM
	+0200


> 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".

You can try TkSql. I wrote it for an Italian company, we use all sort of
accented letters from latin1, it uses TkTable instead of the canvas, maybe
that makes the difference (forms use entries that in turn use different fonts)

> Now we want to get the data into an Excel 97 spreadsheet. This shows the
> same behaviour as opening the tables directly. And I don't know what to do
> about it.

You'll also find a function that allows you to "print on Excel" what you
have on the table (writes out a file and 'start' it or calls Excel on it,
needs two variable to configure).

You'll also find filter and search functions, and if you know a little bit
of tcl/tk you can use direcly the main tcl "bricks" that have planty of
options, hooks for validity checks, inhibit the view of parts of the tables
and so on.

You can find more information on TkSql at

   http://pcco2.mi.infn.it/sd/soft

A rish demo is included in the demo. Simple install script + .rpm, and .deb
license is GPL.


Hope this helps, if you have any problems w/ TkSql, please let me know, I
didn't have much feed-back since I released it (2 months) ago. I have being
using TkSql since a couple of years.


sandro dentella
*:-)

PS. it you are concerned about rewriting some forms, it is as difficoult as
writing:

  set attrs {
      first_name   last_name
      address      -
      address2     -
      phone	   fax
   }
   editDb -attrs $attrs -tbl names -mask

-- 
Sandro Dentella  *:-)
e-mail: sandro@ermit.it sandro.dentella@mi.infn.it 
http://pcco2.mi.infn.it/sd/soft