Re: Servlet on Tomcat + Oracle +ISU 8859-8 (Hebrew CharSet) - encodin g problem

[Veniamin Fichin <3c...@mail.ru>]

Hi there.

    May be this bug report 
<http://issues.apache.org/bugzilla/show_bug.cgi?id=23929> will enlighten 
you, me and others who have issues with i18n. Very professional 
explanation of the problem, thanks to Remy.

yair.fine@hot.net.il wrote:

> The problem:
> I am using Oracle 8.1.7 DB , in a Charest ISU 8859-9-8 ( Hebrew ), I use a
> thin client as the JDBC driver .
> I have a servlet that all it does is getting and updating one of the table
<cut/>
> I  use the doGet method of a servlet to get parameters to retrieve from
> Oracle. this is done through the URL, for example :
> I send the parameters like this :
> http://localhost:8080/myapp/myapp?name=yair
> <http://localhost:8080/myapp/myapp?name=yair&family=fine> &family=fine
> for name= yair, family = fine
>  
> There is no problem in getting and inserting English characters.
> There is a problem when i try to get or to insert Hebrew characters.
> i get ???? in DB , for both if i write yair in the url in Hebrew , or i
> write yair in %E9%E9%E9%F8 which is the decimal representation 
>  
> For example , if i insert a string in Hebrew , it looks like this "?????" (
> in SQL +)
>  
> this is how i get the requests from the url
> Enumeration paramEnum = request.getParameterNames(); // get request
> parameters from the url , in param/value pairs
> String myParam = (String) paramEnum.nextElement(); //get parameter
> String myValue = request.getParameter(myParam);  //get value
>  
> String myStatment = "insert into mytable values('19', '"+myValue+"')" insert
> to table 19 , myvalue
> ResultSet rs = stmt.executeQuery(myStatment);
>  
> does any one have a solution for that ?



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org