mysql乱码问题

最新推荐文章于 2025-04-10 08:07:04 发布

黄瓜和土豆

最新推荐文章于 2025-04-10 08:07:04 发布

阅读量904

点赞数

分类专栏： Mysql 文章标签： mysql database server character jdbc session

本文链接：https://blog.youkuaiyun.com/pengchua/article/details/3444512

版权

Mysql 专栏收录该内容

1 篇文章

订阅专栏

Mysql乱码解决办法
http://download.mysql.cn/ http://mysql.com
mysql版本：mysql-5.0.22-win32.zip 并下载对应的驱动:mysql-connector-java-5.0.8

(1)java中处理中文字符正常,在cmd client中显示乱码是字符集的问题.

(2)字段长度设置够长,但插入中文字符时提示

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too

long for column错误是字符集的问题.

(3)乱码问题归根到底是字符集的问题,那就从字符集设置方面考虑,不外

乎下面几个方面:server,client,database,connection,results.

---------------------------解决办法统一采用utf8编码-------------------------
(1)修改 my.ini(MySQL Server Instance Configuration 文件)
# CLIENT SECTION

[client]

port=3306

[mysql]

default-character-set=gbk

# SERVER SECTION

[mysqld]

default-character-set=utf8

打开my.ini文件然后找到sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION",
删除其中的STRICT_TRANS_TABLES,保存后切

然后重启mysql就ok了

(2)在创建数据库时指定字符集

create database yourDB CHARACTER SET UTF8;

create table xxxx(
username varchar(32),
xxxx
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

(3)在dos命令上要设置

[client]

port=3306

[mysql]

default-character-set=gbk

you don't set "set names 'gbk "';
再查询就可以了.

(4)
jdbc:mysql://localhost:3306/test2?useUnicode=true&characterEncoding=UTF-8
要用&

(5)页面:
<%@ page contentType="text/html; charset=UTF-8" session="false" pageEncoding="UTF-8"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

(6)过滤器:
<filter>
  <filter-name>encodingFilter</filter-name>
  <filter-class>
   org.springframework.web.filter.CharacterEncodingFilter
  </filter-class>
  <init-param>
   <param-name>encoding</param-name>
   <param-value>UTF-8</param-value>
  </init-param>
</filter>
<filter-mapping>
  <filter-name>encodingFilter</filter-name>
  <url-pattern>*.*</url-pattern>
</filter-mapping>