Re: I18n & Pgaccess ( & psql)

Hi Tony,

Thx, for your reply.

On 8 Apr 2002, tony wrote:

> On Mon, 2002-04-08 at 11:49, Leif Jensen wrote:
>
> > I have some problems with international characters and Pgaccess. I don't
> > seem to be able to figure out where the problem is. When I enter a danish
> > character (ascii value above 128, e.g. æøå) in a pgaccess table form
> > (varchar field) it seems to be entered in the database as two bytes. This
> > indicates to me that somewhere the character set might be multibyte
> > (UniCode ??). If I enter the same characters using PgAdmin, they are
> > stored correctly as single byte characters.
> >
> > I have been scanning a lot of docs and logs to figure out how to
> > diagnose the problem, but without luck.
>
> Is your locale set correctly? Tcl/tk is very picky with locale.

Well, I really don't know where to look/check !? I have been living
with non-national characters for a long time myself (but they do work with
programs like elvis, pine, etc.) Some other people in my company now needs
to use some simple entry tool both from Linux and Windows. That's why I
thought Pgaccess would be a good choice.

When you talk about tcl/tk, I suppose you mean the client side!? This
is where I am typing these æøåéè ! Has it something to with the Tcl/Tk
installation/configuration ?

On the Windows side I have just been running an X-server with Pgaccess
running on the PostgreSQL server itself.

>
> I have had accents working but have also learned to live with them not
> working. I don't use pgaccess to enter data just to manipulate it. If I
> want to insert data record by record I use psql.
>
> Cheers
>
> Tony Grant

Sorry for my ignorance in this matter ;-).

Thanks again,

Leif