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.
[EMAIL PROTECTED] wrote:
<cut/>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
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
