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