Java Web application and UTF-8

Java and UTF-8
Generally we can rely on Java as long as source strings are properly encoded. Please refer link:

1. http://java.sun.com/docs/books/tutorial/i18n/text/convertintro.html,
2. http://java.sun.com/javase/technologies/core/basic/intl/faq.jsp

Tomcat and UTF-8

1. JSP pages must include the header: <%@ page contentType="text/html; charset=UTF-8"%>
2. Update the file $CATALINA_HOME/conf/server.xml : add attribute URIEncoding="UTF-8" in Connector tag
3. Add filter as suggested in the link : http://wiki.apache.org/tomcat/Tomcat/UTF-8
4. Tomcat UTF-8 Problem with request.getParameter(), http://answers.google.com/answers/threadview?id=580467
5. useBodyEncodingForURI : http://tomcat.apache.org/tomcat-5.5-doc/config/ajp.html
   

MySql and UTF-8

1. We need our databases and tables to be in utf8 character set : ALTER tables with an SQL statement like - ALTER DATABASE db_name CHARACTER SET utf8 COLLATE utf8_general_ci;
2. Start mysql-demon using option "--character-set-server=utf8" : mysqld ócharacter-set-server=utf8
3. May be useful : http://lists.mysql.com/java/8081

JDBC and UTF-8

1. We can also use useUnicode and characterEncoding properties to configure the JDBC driver to use UTF-8.
2. http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-charsets.html
3. As suggested in the link we can use utf8 encoding either by configuring utf8 as the default server character set in MySql?, or by configuring the JDBC driver to use UTF-8 through the characterEncoding property

XML and UTF-8

1. Add encoding="UTF-8" in (JR)XML header.
   

Others

1. http://blogs.warwick.ac.uk/kieranshaw/entry/utf-8_internationalisation_with
2. UTF-8 in JBoss/Tomcat + MySQL + Hibernate + JavaMail