On what encoding is your MySQL configured? ISO-8859-1 or UTF-8?
Those Ãx means that your characters are in UTF-8. Somehow, something in
your program sends UTF-8 to the DB server.
I've done a webapp totally in UTF-8 without any problem. But I have
to say that I don't have the same config like you. My Tomcat is 5.5.x.
Moreover, are you using the correct JDBC driver from MySQL? And the
most important of all, my MySQL is 4.1 which supports UTF-8 for the
first time, well, if I don't make mistake in understanding this page:
http://www.mysql.com/news-and-events/newsletter/2003-02/a0000000129.html
The question is what encoding you'd like to use. If it's UTF-8,
which IMO is much easier because JVM is already in Unicode, I could help
you. If it's ISO-8859-1, I'm afraid you'd need to do more work to do
your conversion here and there.
Before making the webapp, I've done a sample Java application, a
sort of proof-of-concept, to make that the communication between Java
and MySQL dosn't alter information. Maybe you should do so.
And what's inside the i18n.jsp?
ary martini wrote:
>Hi Team
>
>I am using tomcat 4.1.29 with mysql 4.0
>
>My application runs on tomcat. There is a file "includes.inc.jsp" on my
>application which specifies the character setting to ISO-8859-1.
>
>Issue:
>I cannot insert special characters into my database.
>Example: à , è or ü and ö are inserted as orphan characters like è and ? or Ã
>
>Test:
>I have changed the charset to UTF-8, it has no effect. For some reason tomcat
>deafults the encoding.
>
>Question
>How can I check and change the encoding on tomcat?
>
>Here an extract from my charset :
>
><%@ page language="java" errorPage="/error.jsp" contentType="text/html;
>charset=ISO-8859-1"%>
><link rel="stylesheet" type="text/css" media="screen" href="/css/formate.css">
><%@ include file="session.inc.jsp" %>
><%@ include file="i18n.jsp" %>
><%@ include file="declarations.inc.jsp" %>
><%@ taglib prefix="c" uri="/WEB-INF/tld/c.tld" %>
><%@ taglib prefix="h2h" uri="/WEB-INF/tld/h2h.tld" %>
>
>Thank you very much
>Ary
>
>
>
>---------------------------------
> Yahoo! FareChase - Search multiple travel sites in one click.
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
