Re: Hebrew support -- please help ! - Mailing list pgsql-general

From Guy Naor
Subject Re: Hebrew support -- please help !
Date
Msg-id QU1OVzI2USYoSD1MXVdWLTE0MzE3OTM5MjE@cs-rnt-gnaor
Whole thread Raw
In response to Hebrew support -- please help !  (Elie Nacache <elie_nacache@yahoo.com>)
Responses Re: Hebrew support -- please help !
List pgsql-general
Hi Elie,

>>  I develop an application (JAVA/JSP) on RedHat PostgreSQL 7.4.3 with
>>   PostgreSQL 7.4.2 JDBC3 with SSL (build 213).

>>  This application needs to serve pages in LATIN1 and Hebrew.
>>  For that I create 2 Databases, one DB in UNICODE encoding with client
>>   encoding LATIN1 when in the JSP the charset encoding is iso-8859-1 and
>>   it's working fine from client to server and server to client.

>>  so I decide to do the same thing with Hebrew -- DB in UNICODE with client
>>   encoding ISO-8859-8 when in the JSP the charset encoding is iso-8859-8,
>>   then I got strange characters.

>>  I also tried to create DB in UNICODE encoding with client encoding UNICODE
>>   when in the JSP the charset encoding is UNICODE, but same problem I got
>>   strange characters.

>>  Does someone have a solution or a way to resolve this problem.

Are you sure your client side display and fonts are set correctly? Can you look at the ASCII codes you get back from
Postgresto make sure they are not the correct Hebrew characters. You can send me some strings you got by email and I'll
lookat it if you want. 

Bye,

Guy.

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Hebrew support -- please help !
Next
From: Tim Perkins
Date:
Subject: psqlodbc-07.03.0200 --with-iodbc won7t compile on Mac OS X