mysql的中文问题

blurm

在mysql根目录下搜索my.ini
 
# CLIENT SECTION
[mysql]
 
default-character-set=utf8
 
# SERVER SECTION
[mysqld]
 
default-character-set=utf8
 
然后重启mysql服务
在mysql控制台输入 show variables like '%character%'
 
显示如下：
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | utf8                     |
| character_set_connection | utf8                     |
| character_set_database   | utf8                     |
| character_set_results    | utf8                     |
| character_set_server     | utf8                     |
| character_set_system     | utf8                     |
| character_sets_dir       | C:\mysql\share\charsets\ |
+--------------------------+--------------------------+
 
新建表：
CREATE TABLE `test_article` (
  `oid` bigint(20) NOT NULL auto_increment,
  `title` varchar(50) default NULL,
  `content` text,
  `createdDate` datetime default NULL,
  PRIMARY KEY  (`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
就可以正确插入并显示中文了
 
例如将所有的编码都设置成utf8，jsp的contentType= "text/html;charset=utf-8 "
修改数据库默认编码ALTER   DATABASE   `test`   DEFAULT   CHARACTER   SET   utf8   COLLATE   utf8_bin
修改表的编码：ALTER   TABLE   `category`   DEFAULT   CHARACTER   SET   utf8   COLLATE   utf8_bin    
修改表字段的编码ALTER   TABLE   `test`   CHANGE   `dd`   `dd`   VARCHAR(   45  )   CHARACTER   SET   utf8   COLLATE   utf8_bin   NOT   NULL
 
1。创建数据库的时候：CREATE   DATABASE   `database`
                                                                         CHARACTER   SET    'utf8 '
                                                                            COLLATE    'utf8_general_ci ';
2.建表的时候                              CREATE   TABLE   `database_user`   (
                                                                         `ID`   varchar(40)   NOT   NULL   default    ' ',
                                                                         `UserID`   varchar(40)   NOT   NULL   default    ' ',
                                                                   )   ENGINE=InnoDB   DEFAULT   CHARSET=utf8;
  
3.设置URL的时候                     jdbc:mysql://localhost:3306/database?seUnicode=true&characterEncoding=UTF-8
  
这3个设置好了，基本就不会出问题了