Re: Hebrew support

[[EMAIL PROTECTED]]

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� - <FONT face=Arial 
size=2>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
�
<BLOCKQUOTE dir=ltr 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 
2px solid; MARGIN-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Dave 
  Page 
  To: <A [EMAIL PROTECTED] 
  href="mailto:'[EMAIL PROTECTED]'">'[EMAIL PROTECTED]' ; <A 
  [EMAIL PROTECTED] 
  href="mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED] 
  
  Sent: Monday, February 18, 2002 4:45 
  PM
  Subject: RE: [pgadmin-hackers] Hebrew 
  support
  
  <FONT color=#0000ff 
  size=2>Hi,
  <FONT color=#0000ff 
  size=2>�
  Currently 
  pgAdmin doesn't support Hebrew characters, due to (as I understand it) 
  limitations in Visual Basic. :-(
  <FONT color=#0000ff 
  size=2>�
  Unless someone 
  can tell us otherwise....
  <FONT color=#0000ff 
  size=2>�
  Regards, 
  Dave.
  �
  
  -----Original Message-----From: <A 
  href="mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 
  13:45To: <A 
  href="mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]: 
  [pgadmin-hackers] Hebrew support
  <BLOCKQUOTE dir=ltr 
  style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; 
MARGIN-RIGHT: 0px">
    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