Re: Hebrew support - Mailing list pgadmin-hackers

From Dannyl@barak.net.il
Subject Re: Hebrew support
Date
Msg-id 001901c1b88f$95cc8fd0$0100a8c0@gandalf
Whole thread Raw
In response to Re: Hebrew support  (Dave Page <dpage@vale-housing.co.uk>)
List pgadmin-hackers
Dave,
Thank you -
fwiw - VB supports hebrew fine. 
 
There are two issues I believe - 1 for Pgadmin and 1 for PG
1) Input methods - W2K supports input methods in just about every language known to man.  At installation time you choose lang. support and you're set. This enables you to do a right-alt-shift in W2K and start typing hebrew in any Windows application. It might be an issue of which VB objects for input methods you use or how you use them .
 
 
2) Data encoding  - Windows 2K and Office deal with Unicode as UCS-2. PG encodes with UTF-8.  I think what is happening (and mind you I may be wrong) - is that Pgadmin reads the UTF-8 and being a Windows application tries to display it in whatever encoding it's objects support.  Excel can READ a PG UTF-8 encoded table but needs to export as a Web page in UTF-8 to be able to display the hebrew properly.
 
This is why Pgaccess works ok - it is written in tcl8 and reads UTF-8 from PG and displays the hebrew using it's i18n library.
 
 
HAVING said all this - all I really want to do is to get Postgres 7.1 or 7.2 to order hebrew properly in any encoding - which doesnt seem to work.... -:(
 
Rgrds
Danny
 
----- Original Message -----
From: Dave Page
Sent: Monday, February 18, 2002 4:45 PM
Subject: RE: [pgadmin-hackers] Hebrew support

Hi,
 
Currently pgAdmin doesn't support Hebrew characters, due to (as I understand it) limitations in Visual Basic. :-(
 
Unless someone can tell us otherwise....
 
Regards, Dave.
 
-----Original Message-----
From: Dannyl@barak.net.il [mailto:dannyl@barak.net.il]
Sent: 18 February 2002 13:45
To: pgadmin-hackers@postgresql.org
Subject: [pgadmin-hackers] Hebrew support

i am running Windows 2000 Pro SP2 with the latest version of Pgadmin II 1.2.0
 
i have a Postgres database encoded in Unicode (I tried this in PG7.1 and 7.2) 
Pgadmin doesnt allow me to type Hebrew characters and doesnt display the hebrew at all.
FYI - all the other Windows applications allow data entry of hebrew from Notepad to Office 2K
 
OTOH - pgaccess works just fine - enabling entry and display of hebrew.
 
danny lieberman

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Hebrew support
Next
From: Dave Page
Date:
Subject: Re: Hebrew support