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

From Ulrich Wisser
Subject Re: Hebrew support -- please help !
Date
Msg-id 4136DF18.9000509@relevanttraffic.se
Whole thread Raw
In response to Re: Hebrew support -- please help !  (Elie Nacache <elie_nacache@yahoo.com>)
Responses Re: Hebrew support -- please help !  (Elie Nacache <elie_nacache@yahoo.com>)
List 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



pgsql-general by date:

Previous
From: reina_ga@hotmail.com (Tony Reina)
Date:
Subject: Re: can't build libpq with beta 2
Next
From: Ulrich Wisser
Date:
Subject: Foreign key locks