使用了免安装版mysql,可是创建表项时无法插入汉字,我按照网上有些网友说的将my-medium.ini复制为my.ini并添加了default-character-set=utf8后,发现mysqld.exe无法启动,也就是无法启动mysql服务。删除my.ini后服务可以启动,但还是无法插入汉字字符,将default-character-set=utf8添加到my-medium.ini my-small.ini my-large.ini后依然无法插入汉字。怎么办
调试欢乐多
,'www.mldn.cn','30','男','2010-09-09');
Query OK, 1 row affected, 2 warnings (0.00 sec)MariaDB [mldn]> show warnings
-> ;
+---------+------+-------------------------------------------------------------
-----------------+
| Level | Code | Message
|
+---------+------+-------------------------------------------------------------
-----------------+
| Warning | 1366 | Incorrect string value: '\xC0\xEE\xC7\xE5\xBB\xAA' for colum
'name' at row 1 |
| Warning | 1366 | Incorrect string value: '\xC4\xD0' for column 'sex' at row 1
|
+---------+------+-------------------------------------------------------------
-----------------+
2 rows in set (0.00 sec)还是出现上面的警告汉字无法显示。
MariaDB [mldn]> select * from user
-> ;
+----+------+-------------+-----+------+------------+
| id | name | password | age | sex | birthday |
+----+------+-------------+-----+------+------------+
| 1 | ??? | www.mldn.cn | 30 | male | 2008-08-27 |
| 2 | ??? | www.mldn.cn | 30 | male | 1989-02-09 |
| 3 | ??? | www.mldn.cn | 30 | ? | 2010-09-09 |
+----+------+-------------+-----+------+------------+
3 rows in set (0.00 sec)MariaDB [mldn]>
然后再插入
--------------
mysql Ver 15.1 Distrib 5.5.25-MariaDB, for Win32 (x86)Connection id: 1
Current database: mldn
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server: MariaDB
Server version: 5.5.25-MariaDB mariadb.org binary distribution
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: gbk
Conn. characterset: latin1
TCP port: 3306
Uptime: 15 min 12 secThreads: 1 Questions: 20 Slow queries: 0 Opens: 34 Flush tables: 1 Open tab
les: 27 Queries per second avg: 0.021
--------------
set names 'gbk';
MySQL 中文显示乱码
网页打不开,请问,里面有没有包含这样一种情况:MySQL workbench的E-R图设计界面和起始界面不能显示中文?