mysql中文乱码问题,命令方式正确,MySQL Maestro工具正确,jsp页面错误,mysql-front错误
mysql乱码问题, 请求解决方法
全部是utf8编码.
命令方式查询,先执行set names 'latin1 ',然后正确,不执行set names 'latin1 ',出现乱码....
MySQL Maestro工具查询正确,
jsp页面查询乱码
但是用new String(rs.getString(1).getBytes( "iso_8859_1 "), "gbk ")转换后就正确了.....
mysql-front查询,乱码............
请求大家给个方法...弄了一晚上没弄出来........
[解决办法]
装MYSQL的时候字符集选GB2312啊
[解决办法]
全部是utf8编码.
装mysql时也是要utf8的。
[解决办法]
在mysql里建表的时候加上 ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE `depart` (
`id` int(5) NOT NULL auto_increment,
PRIMARY KEY (`id`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
[解决办法]
你可以把mysql 的配置文件改了.
把他的编码改成gbk 或者 gb2312
然后重新启动服务. 这样不会有MYSQL 的中文问题了.
[解决办法]
编码格式统一就OK了
jsp页面改成utf-8
数据库整理改成utf-8
源码文件也改成utf-8
[解决办法]
界面，数据库，jsp的代码都要编码一致，实在有问题用强制转换
[解决办法]
我感觉如果是数据库里面也是乱码的话,就从你往数据库里面写数据的地方找.
[解决办法]
1、建议mysql使用gbk编码！
C:\WINNT> type my.ini
[mysqld]
basedir=D:/mysql
datadir=D:/mysql-data/data
default-character-set=gbk
[client]
default-character-set=gbk
2 连接mysql的时候,使用这样的url就能够搞定了!
String url = "jdbc:mysql://localhost:3306/sunnywest?useUnicode=true&characterEncoding=gbk ";
String user = "root ";
String password = "dada ";
Connection connRemoteMysql = DriverManager.getConnection(url, user, password);
[解决办法]
编码格式统一就OK了 ,但我建议还都是统一用utf-8编码！！！！！！！
希望能帮到你！！！！！
[解决办法]
mysql-front 设置成utf-8或GBK 中文的。。。
连库也指定编码。。。
jdbc:mysql://127.0.0.1:3306/authdb?useUnicode=true&characterEncoding=gb2312
[解决办法]
设置一个过滤器，
web.xml加
<filter>
<filter-name> SetCharacterEncodingFilter </filter-name>
<filter-class> com.hotpepper.util.SetCharacterEncodingFilter </filter-class>
<init-param>
<param-name> encoding </param-name>
<param-value> UTF-8 </param-value>
</init-param>
<init-param>
<param-name> ignore </param-name>
<param-value> true </param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name> SetCharacterEncodingFilter </filter-name>
<url-pattern> /* </url-pattern>
</filter-mapping>
public class SetCharacterEncodingFilter
implements Filter {
// ----------------------------------------------------- Instance Variables
/**
* The default character encoding to set for requests that pass through
* this filter.
*/
protected String encoding = null;
/**
* The filter configuration object we are associated with. If this value
* is null, this filter instance is not currently configured.
*/
protected FilterConfig filterConfig = null;
// --------------------- Public Methods
/**
* Take this filter out of service.
*/
public void destroy() {
this.encoding = null;
this.filterConfig = null;
}
/**
* Select and set (if specified) the character encoding to be used to
* interpret request parameters for this request.
*
* @param request The servlet request we are processing
* @param result The servlet response we are creating
* @param chain The filter chain we are processing
*
* @exception IOException if an input/output error occurs
* @exception ServletException if a servlet error occurs
*/
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException {
String encoding = selectEncoding(request);
if (encoding != null) {
request.setCharacterEncoding(encoding);
} else {
request.setCharacterEncoding(encoding);
}
response.setContentType( "text/html;charset=UTF-8 ");
// Pass control on to the next filter
chain.doFilter(request, response);
}
/**
* Place this filter into service.
*
* @param filterConfig The filter configuration object
*/
public void init(FilterConfig filterConfig) throws ServletException {
this.filterConfig = filterConfig;
this.encoding = filterConfig.getInitParameter( "encoding ");
}
// ------------------------------------------------------ Protected Methods
/**
* Select an appropriate character encoding to be used, based on the
* characteristics of the current request and/or filter initialization
* parameters. If no character encoding should be set, return
* <code> null </code> .
* <p>
* The default implementation unconditionally returns the value configured
* by the <strong> encoding </strong> initialization parameter for this
* filter.
*
* @param request The servlet request we are processing
*/
protected String selectEncoding(ServletRequest request) {
return (this.encoding);
}
}
