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

Hi,

 

> 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 ?

 

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 !?

 

Elie