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

Re: Hebrew support -- please help !

From: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>
To: Elie Nacache <elie_nacache(at)yahoo(dot)com>
Cc: Guy Naor <guy_naor(at)speakeasy(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Hebrew support -- please help !
Date: 2004-08-31 16:23:23
Message-ID: 4134A5FB.9020004@wardbrook.com (view raw or flat)
Thread:
Lists: pgsql-general
 > 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.
 >
 > What happen here ! something else to config ?

This is a Tomcat question...

When processing forms set the encoding of the form element using the 
following attribute (in addition to all that you are doing):

enctype= "text/plain;charset=UTF-8"

eg <form action="blah" ... enctype= "text/plain;charset=UTF-8">

Also add a hidden field with special/accented characters in all your 
forms. Query the parameter value (of the hidden field) in your 
servlet/filter/jsp to see what you actually got. It could be that the 
browser didn't respect your encoding, and you don't get back what you 
put there in the first place!

Hope that helps.

John Sidney-Woollett

Elie Nacache wrote:

> Hi Guy,
>  
> 
>>Are you sure your client side display and fonts are set correctly? 
> 
>  
> Yes, I can display Hebrew font.
>  
> 
>>Can you look at the ASCII codes you get back from Postgres to make sure they are not the correct Hebrew characters.
> 
>  
> I use pgAdmin3 on W2K to insert row in Hebrew and can see the right character.
>  
> My /etc/sysconfig/i18n file:
> LANG="en_US.UTF-8"
> SUPPORTED="fr_FR.UTF-8:fr_FR:fr:en_US.UTF-8:en_US:en"
> SYSFONT="latarcyrheb-sun16"
> 
> Now I tried this configuration: 
>   * DB in UNICODE, 'set client_encoding to UNICODE'
>   * Apache 2.0 + mod_jk2: don't see any encoding
>   * Tomcat 5:  javaEncoding to UTF8 (default value)
>   * In each JSP: 
>        <%@ page contentType="text/html;charset=utf-8" language="java"%>
>        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
>  
> 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.
>  
> What happen here ! something else to config ?
>  
> Elie
> 
> 		
> ---------------------------------
> Do you Yahoo!?
> Win 1 of 4,000 free domain names from Yahoo! Enter now.

In response to

pgsql-general by date

Next:From: Thomas F.O'ConnellDate: 2004-08-31 17:00:11
Subject: Multicolumn Primary Key
Previous:From: Elie NacacheDate: 2004-08-31 15:54:07
Subject: Re: Hebrew support -- please help !

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