Thread: Pgaccess - localization problem

Pgaccess - localization problem

From
"Ловпаче Айдамир"
Date:
Please help me with pgaccess localization! I use the PosgtgeSQL
as a base RDBMS for my students in a course of database development. I have set the
russian.koi8-r localization and the koi-8 fonts, in the setup form, but have 
got nothing effect?    Thats the first problem, but the main problem is an impossibility 
of input russian symbols, and see the output (output's like a missing font 
charset) in all pgaccess forms. 

I use:

tcl/tk 8.3
Slakware Linux 7.1 2.2.18 
PostgresSQL 7.0.3 (pgaccess 98.5?)
Xserver 3.3.6
the system and Xwindow propely localized. Nothing problems with russian input 
and output in all Xapplications, except tcl-based (no input).  
XF86config attached if needed.

I am not familiar with tcl programming, but through a couple of expirements 
with modifying the intlmsg procedure, it becomes clear, that: 
 $Messages($msg) does't return anything independently of presenting   such element. However array get - does it
properly. 
 


proc {intlmsg} {msg} {
global PgAcVar Messagestk_messageBox -title Archibald Warning -parent .pgaw:Preferences -message
$PgAcVar(pref,language)#Displays properly encoding - russian.koi8-rif {$PgAcVar(pref,language)=="english"} { return
$msg}if { ! [array exists Messages] } { return $msg }tk_messageBox -title "Debug" -message "Массив существует"#
Displaysthe properly encoded message? if { ! [info exists Messages($msg)] } { return $msg }tk_messageBox -title "Debug"
-message"info after"# that's never display'sreturn $Messages($msg)
 
}         
my .pgaccessrc
pref,font_normal {-cronyx-Helvetica-Medium-R-Normal--*-*-*-100-*-*-koi8-r}
pref,font_bold {-cronyx-Helvetica-Bold-R-Normal--*-*-*-100-*-*-koi8-r}
pref,username {}
pref,autoload {1}
pref,typecolors {black red brown #007e00 #004e00 blue orange yellow pink purple cyan  magenta lightblue lightgreen gray
lightyellow}
pref,font_fix {-cronyx-helvetica-r-normal--*-*-*-100-*-*-koi8-r"}
pref,systemtables {1}
pref,lastport {5432}
pref,tvfont {helv}
pref,lasthost {localhost}
pref,lastdb {polic}
pref,password {}
pref,rows {200}
pref,lastusername {}
pref,language {russian.koi8r}
pref,font_italic {-cronyx-Helvetica-Medium-R-Normal--*-*-*-100-*-*-koi8-r"}
pref,typelist {text bool bytea float8 float4 int4 char name int8 int2 int28 regproc oid tid xid cid}

It seems to me - that tcl does not recognize 8-bit character? 
But I have found nothing about it in manuals. 

Sorry for my english.

Thank you! please answer to aidanet@yandex.ru or aidamir@mail.ru
                        Aidamir Lovpache 






Re: Pgaccess - localization problem

From
Tatsuo Ishii
Date:
> Please help me with pgaccess localization! I use the PosgtgeSQL
> as a base RDBMS for my students in a course of database development. I have set the
> russian.koi8-r localization and the koi-8 fonts, in the setup form, but have 
> got nothing effect? 
>     Thats the first problem, but the main problem is an impossibility 
> of input russian symbols, and see the output (output's like a missing font 
> charset) in all pgaccess forms. 
> 
> I use:
> 
> tcl/tk 8.3
> Slakware Linux 7.1 2.2.18 
> PostgresSQL 7.0.3 (pgaccess 98.5?)
> Xserver 3.3.6
> the system and Xwindow propely localized. Nothing problems with russian input 
> and output in all Xapplications, except tcl-based (no input).  
> XF86config attached if needed.
> 
> I am not familiar with tcl programming, but through a couple of expirements 
> with modifying the intlmsg procedure, it becomes clear, that: 
> 
>   $Messages($msg) does't return anything independently of presenting  
>   such element. However array get - does it properly.  
[snip]
> It seems to me - that tcl does not recognize 8-bit character? 

Tcl 8.3 uses Unicode internally and that might be the source of your
problem. Not sure, but it looks like Tcl fails to convert KOI-8 to
Unicode. Try downgrading to Tcl 8.0.

BTW, pgaccess + tcl8.3 can only live with Unicode database:
i.e. databses created with -E UNICODE.
--
Tatsuo Ishii