OFBiz開發時遇到亂碼的問題，MySQL數據庫插入中文數據時出現了一個問題，報告中文錯誤：incorrect string value ．．．．．
1.這時由于字符編碼不一致導致的，應該將數據庫對應的表或coloum改成uft-8，所以如果在CustomerExtra這表中存儲中文的話，需要將
此表另外還有operationlog表的charset改成utf-8
2.Servlet中字符顯示為證券的中文，而且表也設置為utf-8，但是數據庫和頁面還是亂碼，怎么回事？
這里需要修改jdbc url的參數，如將jdbc:mysql://localhost/ccbportal?zeroDateTimeBehavior=convertToNull
改成：jdbc:mysql://localhost/ccbportal?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8
3.前臺輸入的是中文，到后臺就變成了亂碼，怎么回事？
無論何種表單提交都可以在后臺的java文件中通過String des = new String(s.getBytes("iso8859-1"),"UTF-8");
來轉換成你想要的UTF－8編碼方式。但如果每處都加詞句太麻煩，故分post和get兩種方式區分提交。
寫一個Filter即可解決問題：
1
2 import java.io.IOException;
3 import javax.servlet.ServletException;
4 import javax.servlet.Filter;
5 import javax.servlet.FilterChain;
6 import javax.servlet.FilterConfig;
7
8 import javax.servlet.ServletRequest;
9 import javax.servlet.ServletResponse;
10
11 public class SetCharacterEncodingFilter implements Filter {
12
13 protected String encoding = "GBK";
14
15 protected FilterConfig filterConfig = null;
16
17 protected boolean ignore = true;
18
19 public void init(FilterConfig filterConfig) throws ServletException {
20 this.filterConfig = filterConfig;
21 this.encoding = filterConfig.getInitParameter("encoding");
22 String value = filterConfig.getInitParameter("ignore");
23 if (value == null)
24 this.ignore = true;
25 else if (value.equalsIgnoreCase("true"))
26 this.ignore = true;
27 else if (value.equalsIgnoreCase("yes"))
28 this.ignore = true;
29 else
30 this.ignore = false;
31 }
32
33 public void doFilter(ServletRequest request, ServletResponse response,
34 FilterChain chain) throws IOException, ServletException {
35 // Conditionally select and set the character encoding to be used
36 if (ignore || (request.getCharacterEncoding() == null)) {
37 String encoding = selectEncoding(request);
38 if (encoding != null) {
39 request.setCharacterEncoding(encoding);
40 }
41
42 }
43 // Pass control on to the next filter
44 chain.doFilter(request, response);
45 }
46
47 protected String selectEncoding(ServletRequest request) {
48 return (this.encoding);
49 }
50
51 public void destroy() {
52 this.encoding = null;
53 this.filterConfig = null;
54 }
55 }
56
web.xml添加此Filter：
1 <filter>
2 <filter-name>encodeFilter</filter-name>
3 <filter-class> com.aicent.ccb.filter.SetCharacterEncodingFilter</filter-class>
4 <init-param>
5 <param-name>encoding</param-name>
6 <param-value>GBK</param-value>
7 </init-param>
8 <init-param>
9 <param-name>ignore</param-name>
10 <param-value>true</param-value>
11 </init-param>
12 </filter>
13 <filter-mapping>
14 <filter-name>encodeFilter</filter-name>
15 <url-pattern>/control/*</url-pattern>
16 </filter-mapping>