pgaccess: russian fonts && SQL window???

tolik@aaanet.ru (Anatoly K. Lasareff) writes:

Two questions about pgaccess. I use tkl/Tk 8.2, Postgresql 7.1,
FreeBSD 4.0 .

1. I cannot view russian text in russian when I use pgaccess. I set all
the fonts in 'Preferences' to
-cronyx-helvetica-*-*-*-*-17-*-*-*-*-*-koi8-* , but don't see russian
letters in 'tables' and others windows. The texts are really in
russian, DBENCODING is KOI8.

Hm. We've had a couple of reports recently that suggest that there's
a character-set-translation problem between Postgres and recent Tcl/Tk
releases --- which seems to describe your problem as well. I have an
unproven suspicion that this is related to Tcl's changeover to UTF-8
internal representation, because the reports have all come from people
running Tcl 8.2 or later. But no one's done the work yet to understand
the problem in detail or propose a fix. Want to dig into it?

regards, tom lane

1. I cannot view russian text in russian when I use pgaccess. I set all
the fonts in 'Preferences' to
-cronyx-helvetica-*-*-*-*-17-*-*-*-*-*-koi8-* , but don't see russian
letters in 'tables' and others windows. The texts are really in
russian, DBENCODING is KOI8.

Hm. We've had a couple of reports recently that suggest that there's
a character-set-translation problem between Postgres and recent Tcl/Tk
releases --- which seems to describe your problem as well. I have an
unproven suspicion that this is related to Tcl's changeover to UTF-8
internal representation, because the reports have all come from people
running Tcl 8.2 or later. But no one's done the work yet to understand
the problem in detail or propose a fix. Want to dig into it?

regards, tom lane

I have used Postgres and Tcl/Tk for quite some time and yes, when 8.2 came
out, I had trouble accessing ANYTHING because of the UTF-8 switch. My
solution was to upgrade my pgsql.tcl file with a new one. I tried it once
and it worked but other events have prevented me from switching all of my
code yet. Pgsql.tcl is a tcl source only interface to postgres (as opposed
to a .dll or .so). Whether the changes in there have made it into
libpgtcl.so/dll I don't know. I would be happy to forward it somewhere if
you would like to try it out.

len morgan

"Len Morgan" <len-morgan@crcom.net> writes:

I have used Postgres and Tcl/Tk for quite some time and yes, when 8.2 came
out, I had trouble accessing ANYTHING because of the UTF-8 switch. My
solution was to upgrade my pgsql.tcl file with a new one. I tried it once
and it worked but other events have prevented me from switching all of my
code yet. Pgsql.tcl is a tcl source only interface to postgres (as opposed
to a .dll or .so). Whether the changes in there have made it into
libpgtcl.so/dll I don't know. I would be happy to forward it somewhere if
you would like to try it out.

Yes, I'd like to see it. It'd be even more useful if you also have the
old version, so I can see what was changed to fix the problem.

regards, tom lane