MYSQL 内存表 有能存中文的字段类型么

Question

MYSQL 内存表 有能存中文的字段类型么

Answer 1

可以。
mysql> create table tttt(`中文` int) engine=memory;
Query OK, 0 rows affected (0.05 sec)mysql> insert into tttt values(1);
Query OK, 1 row affected (0.00 sec)mysql> select * from tttt;
+------+
| 中文 |
+------+
|    1 |
+------+
1 row in set (0.00 sec)mysql> show variables like 'char%';
+--------------------------+-------------------------------------------+
| Variable_name            | Value                                     |
+--------------------------+-------------------------------------------+
| character_set_client     | gbk                                       |
| character_set_connection | gbk                                       |
| character_set_database   | gbk                                       |
| character_set_results    | gbk                                       |
| character_set_server     | gbk                                       |
| character_set_system     | utf8                                      |
| character_sets_dir       | d:\mysql-5.0.9-beta-win32\share\charsets/ |
+--------------------------+-------------------------------------------+
7 rows in set (0.00 sec)

Answer 2

内存表 好像没法创建Text 类型的 

Answer 3

不错： 
The used table type doesn't support BLOB/TEXT columns
你只能用varchar类型来存储文本了。

Answer 4

关键是 varchar 没法存中文啊 

Answer 5

不会吧，照着我下边的执行一遍：
mysql> create table tttt(id varchar(100)) engine=memory;
Query OK, 0 rows affected (0.06 sec)mysql> insert into tttt values('中文中文中文中文中文中文');
Query OK, 1 row affected (0.00 sec)mysql> select * from tttt;
+--------------------------+
| id                       |
+--------------------------+
| 中文中文中文中文中文中文 |
+--------------------------+
1 row in set (0.00 sec)mysql> show variables like 'char%';
+--------------------------+-------------------------------------------+
| Variable_name            | Value                                     |
+--------------------------+-------------------------------------------+
| character_set_client     | gbk                                       |
| character_set_connection | gbk                                       |
| character_set_database   | gbk                                       |
| character_set_results    | gbk                                       |
| character_set_server     | gbk                                       |
| character_set_system     | utf8                                      |
| character_sets_dir       | d:\mysql-5.0.9-beta-win32\share\charsets/ |
+--------------------------+-------------------------------------------+
7 rows in set (0.00 sec)mysql> select @@version;
+---------------+
| @@VERSION     |
+---------------+
| 5.0.9-beta-nt |
+---------------+

Answer 6

mp3aaa
等　级： 
结帖率：102.19% 
哥们，你的结贴率怎么是102啊？怎么弄上去的啊？
不知道大家发现了没有

Answer 7

参考一下贴子听有关字符集的介绍。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码