请问怎么改字符集

Question

mysql> select case when 'A' collate gbk_chinese_ci='a' collate gbk_chinese_ci then 1 else 0 end;
ERROR 1253 (42000): COLLATION 'gbk_chinese_ci' is not valid for CHARACTER SET 'latin1'请问怎么改字符集啊  要不要改变呢

Answer 1

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 2

不是先改字符集
  在查询语句么 ？
  set name 字符类型 
 在select 

Answer 3

此文章可以助你，我也一同学习一番：MySQL字符集修改命令1.修改服务器级 a. 临时更改： mysql>SET GLOBAL character_set_server=utf8; b. 永久更改：shell>vi /etc/my.cnf[mysqld]default-character-set=utf82.修改数据库级 a. 临时更改： mysql>SET GLOBAL character_set_database=utf8; b. 永久更改：改了服务器级就可以了3.修改表级 mysql>ALTER TABLE table_name DEFAULT CHARSET utf8; 更改了后永久生效4.修改列级修改示例： mysql>ALTER TABLE `products` CHANGE `products_model` `products_model` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL; 更改了后永久生效 5.更改连接字符集 a. 临时更改：mysql> SET NAMES utf8;b. 永久更改： shell>vi /etc/my.cnf在[client]中增加：default-character-set=utf8mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name       | Value          |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server    | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.02 sec)
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name          | Value                       |
+--------------------------+----------------------------+
| character_set_client    | utf8                      |
| character_set_connection | utf8                      |
| character_set_database | utf8                      |
| character_set_filesystem | binary                   |
| character_set_results     | utf8                      |
| character_set_server    | utf8                      |
| character_set_system    | utf8                      |
| character_sets_dir        | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+查看服务器和客户端字符集 
mysql> show variables like "%char%"; 
+--------------------------+------------------------------------+ 
| Variable_name | Value | 
+--------------------------+------------------------------------+ 
| character_set_client | utf8 | 
| character_set_connection | utf8 | 
| character_set_database | utf8 | 
| character_set_filesystem | binary | 
| character_set_results | utf8 | 
| character_set_server | utf8 | 
| character_set_system | utf8 | 
| character_sets_dir | D:\MySQL\MySQL 5.0\share\charsets\ | 
+--------------------------+------------------------------------+ 
8 rows in set (0.09 sec) mysql> show variables like "%colla%"; 
+----------------------+-----------------+ 
| Variable_name | Value | 
+----------------------+-----------------+ 
| collation_connection | utf8_general_ci | 
| collation_database | utf8_general_ci | 
| collation_server | utf8_general_ci | 
+----------------------+-----------------+ 
3 rows in set (0.00 sec) 查看数据库的字符集 
mysql> show create database test; 
+----------+---------------------------------------------------------------+ 
| Database | Create Database | 
+----------+---------------------------------------------------------------+ 
| test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8 */ | 
+----------+---------------------------------------------------------------+ 
1 row in set (0.00 sec) 查看表的字符集,包括各个字段的字符集,如果各字段没有标明,表示与表的字符集一致 
mysql> show create table books \G 
*************************** 1. row *************************** 
Table: books 
Create Table: CREATE TABLE `books` ( 
`id` varchar(8) NOT NULL default '', 
`name` varchar(24) NOT NULL default '', 
`title` varchar(96) NOT NULL default '', 
`price` float NOT NULL default '0', 
`yr` int(4) unsigned NOT NULL default '0', 
`description` varchar(30) NOT NULL default '', 
`saleAmount` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=gbk 
1 row in set (0.01 sec)  通过MySQL命令行修改:mysql> set character_set_client=utf8;
Query OK, 0 rows affected (0.00 sec)mysql> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)mysql> set character_set_server=utf8;
Query OK, 0 rows affected (0.00 sec)mysql> set character_set_system=utf8;
Query OK, 0 rows affected (0.01 sec)mysql> set collation_connection=utf8;
Query OK, 0 rows affected (0.01 sec)mysql> set collation_database=utf8;
Query OK, 0 rows affected (0.01 sec)mysql> set collation_server=utf8;
Query OK, 0 rows affected (0.01 sec)
查看:
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.03 sec)mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.04 sec)