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

Re: Hebrew support -- please help !

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: elie_nacache(at)yahoo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Hebrew support -- please help !
Date: 2004-08-31 01:06:21
Message-ID: 20040831.100621.74737500.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-general
> Hi all,
>  
> 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.

If I understand correctly, JDBC driver issues "set client_encoding to
iso-8859-8" in your case. You should check it first. If it does the
right thing, then you might want to the conversion maps. They are located:

src/backend/utils/mb/Unicode/utf8_to_iso8859_8.map	// UNICODE(UTF-8) -> ISO-8859-8
src/backend/utils/mb/Unicode/iso8859_8_to_utf8.map	// ISO-8859-8 -> UNICODE(UTF-8)

If you find anything wrong, please let me know.
--
Tatsuo Ishii

In response to

pgsql-general by date

Next:From: Guy NaorDate: 2004-08-31 01:35:24
Subject: Re: Hebrew support -- please help !
Previous:From: David WheelerDate: 2004-08-31 00:39:57
Subject: Re: UTF-8 and LIKE vs =

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