Skip site navigation (1) Skip section navigation (2)

Re: Hebrew support -- please help !

From: Guy Naor <guy_naor(at)speakeasy(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Hebrew support -- please help !
Date: 2004-08-31 01:35:24
Message-ID: QU1OVzI2USYoSD1MXVdWLTE0MzE3OTM5MjE@cs-rnt-gnaor (view raw or flat)
Thread:
Lists: 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 Postgres to make sure they are not the correct Hebrew characters. You can send me some strings you got by email and I'll look at it if you want.

Bye,

Guy.

In response to

Responses

pgsql-general by date

Next:From: Tim PerkinsDate: 2004-08-31 02:36:21
Subject: psqlodbc-07.03.0200 --with-iodbc won7t compile on Mac OS X
Previous:From: Tatsuo IshiiDate: 2004-08-31 01:06:21
Subject: Re: Hebrew support -- please help !

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group