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 11:58:11
Message-ID: 20040831.205811.55737797.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-general
> > 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.
>  
> I installed postgresql from a rpm files:
>   * postgresql-7.4.3-2PGDG.i686.rpm
>   * postgresql-jdbc-7.4.3-2PGDG.i686.rpm
>   * postgresql-libs-7.4.3-2PGDG.i686.rpm
>   * postgresql-server-7.4.3-2PGDG.i686.rpm
>  
> So in my installation there are no map file but there are a lot of so's in /usr/lib/pgsql.
> I can observe that there is no utf8_and_iso8859_8.so file. How can I got/compile this file ?

It's in utf8_and_iso8859.so.

> The second solution, that I prefer but that failed was to work server/client side only in utf8. The DB was UNICODE, the 'show client_encoding' returned unicode and the charset in the jsp was utf-8. Any idea !?

In PostgreSQL, unicode, utf8 and utf-8 are all equivalent.
--
Tatsuo Ishii

In response to

pgsql-general by date

Next:From: Raymond O'DonnellDate: 2004-08-31 12:37:39
Subject: Re: European dates with Win32 version
Previous:From: Elie NacacheDate: 2004-08-31 11:34:00
Subject: Re: Hebrew support -- please help !

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