匿名用戶

1級(jí)

2018-11-18 回答

中文字段名都可以了 但是中文記錄不行 奇怪啊

mysql>; create table a (a char(20));

Query OK, 0 rows affected (0.05 sec)

mysql>; insert into a values('^_^');

Query OK, 1 row affected (0.05 sec)

mysql>; insert into a values('中g(shù)uo');

Query OK, 1 row affected (0.05 sec)

mysql>; insert into a values('中國');

Query OK, 1 row affected (0.05 sec)

mysql>; insert into a values('中');

Query OK, 1 row affected (0.01 sec)

mysql>; select * from a;

+-------+

| a |

+-------+

| ^_^ |

| ??guo |

| ???? |

| ?? |

+-------+

4 rows in set (0.00 sec)

mysql>; create table t2 (中 char(20));

Query OK, 0 rows affected (0.05 sec)

mysql>; insert into t2 values('"中g(shù)uo"');

Query OK, 1 row affected (0.03 sec)

mysql>; select * from t2;

+---------+

| 中 |

+---------+

| "??guo" |

+---------+

1 row in set (0.00 sec)

mysql>; status;

--------------

mysql Ver 14.7 Distrib 4.1.7, for Win95/Win98 (i32)

Connection id: 2

Current database: test1

Current user: root@localhost

SSL: Not in use

Using delimiter: ;

Server version: 4.1.7-nt

Protocol version: 10

Connection: localhost via TCP/IP

Server characterset: latin1

Db characterset: gbk

Client characterset: gb2312

Conn. characterset: latin1

TCP port: 3306

Uptime: 35 min 18 sec

Threads: 1 Questions: 43 Slow queries: 0 Opens: 21 Flush tables: 1 Open tables: 2 Queries per second avg: 0.020

總結(jié)

以上是生活随笔為你收集整理的mysql 字段 中文_如何配置mysql支持中文字段名与中文字段的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。