Re: Hebrew support -- please help !

From: Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se>
To: Elie Nacache <elie_nacache(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Hebrew support -- please help !
Date: 2004-09-02 08:51:36
Message-ID: 4136DF18.9000509@relevanttraffic.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Elie,

> Now I got the right information from the DB in Hebrew and french.
> Still can't save value in Hebrew from client (browser) to server and in
> french if I save 'été' in a column varchar(3) I got a range over exception.

you are working through the web. That makes the whole thing a lot more
complex. Try to use UTF-8/UNICODE encoding all the way. That means
configure Apache(!!!) and Tomact to server pages in UTF-8 encoding.
All web pages pages should have

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

Check in your browser if UTF-8 encoding is used. On the other operating
system in IE use View > Encoding, it should show UTF-8.

Actually the browser to server communication is the hardest to ensure
the right encoding is used.

We have a database with Japanese, Hebrew, German, Swedish, French,
Spanish and English content.

Ulrich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ulrich Wisser 2004-09-02 09:06:05 Foreign key locks
Previous Message Tony Reina 2004-09-02 08:21:15 Re: can't build libpq with beta 2