I have recently has the same problem to happen on MySQL & MSSQL. When Tomcat Server is normal in Windows, there is a garbled when transplanted into Solaris, and after the previous article, there will be no problem now, my setting is as follows. : 1. MySQL Server 4.0.22, Tomcat 5.0.28, the Connection URL is set as follows: driver = "org.gjt.mm.mysql.driver"; URL = "JDBC: mysql: //xx.xx.xx.xx: 3306 / xxxx? Autoreconnect = true & useful = true & characterencoding = utf-8 "; user =" xxxxxx "; password =" xxxxxx "; 2. MSSQL part, JDBC Driver uses JTDS V0.9.1, you need to pay attention, whether SQL 7.0 or 2000, if Tomcat is enclosed in Solaris, the Connection URL needs to set the following parameters to display Chinese normally, otherwise there will be Exception appearance. Driver = "net.sourceforge.jtds.jdbc.driver"; url = "JDBC: JTDS: SQLServer : // xxxxxx: 1433 / xxxxxx; TDS = 7.0 "; user =" xxxxxx "; password =" xxxxxx "; 3 increases a character Encode Filter, as follows:. HttpServletRequest req = (HttpServletRequest) request; HttpServletResponse res = (HttpServletResponse ) Response; res. "Text / HTML; Charset = UTF-8"); Req.SetCharacterencoding ("UTF-8"); 4. All JSP is defined as follows: <% @ Page ContentType = "Text / HTML Charset = UTF-8 "Language =" java "%> This Chinese problem is Turn around!!
