CREATE TABLE MoneyDef (
autoid int auto_increment NOT NULL primary key,
runcarid int NULL ,
costname varchar (50),
costcomment varchar (50),
money decimal(18, 0) NULL
)DEFAULT CHARSET=utf8; INSERT INTO MoneyDef(runcarid, costname, costcomment, money) VALUES ('3','tcf','停车费','10');
INSERT INTO MoneyDef(runcarid, costname, costcomment, money) VALUES ('3','glf','过路费','50');
INSERT INTO MoneyDef(runcarid, costname, costcomment, money) VALUES ('3','wxf','维修费','200');C程序里用下面的方法
mysql_init(&my);
if (mysql_real_connect(&my, "localhost", "root", "", "test", 0, NULL, 0)) {
printf("Connection success\n"); mysql_query(&my,"SET NAMES utf8");
char *querydata = "INSERT INTO MoneyDef(runcarid, costname, costcomment, money) VALUES ('5','xcf',CONVERT('洗车费' USING UTF8),'120')";
res = mysql_query(&my, querydata);插入正确但是
mysql> select * from MoneyDef;
+--------+----------+----------+-------------+-------+
| autoid | runcarid | costname | costcomment | money |
+--------+----------+----------+-------------+-------+
| 1 | 5 | xcf | laoliu | 120 |
| 2 | 5 | xcf | ??? | 120 |
+--------+----------+----------+-------------+-------+
2 rows in set (0.00 sec)
啥原因呢???郁闷中。
autoid int auto_increment NOT NULL primary key,
runcarid int NULL ,
costname varchar (50),
costcomment varchar (50),
money decimal(18, 0) NULL
)DEFAULT CHARSET=utf8; INSERT INTO MoneyDef(runcarid, costname, costcomment, money) VALUES ('3','tcf','停车费','10');
INSERT INTO MoneyDef(runcarid, costname, costcomment, money) VALUES ('3','glf','过路费','50');
INSERT INTO MoneyDef(runcarid, costname, costcomment, money) VALUES ('3','wxf','维修费','200');C程序里用下面的方法
mysql_init(&my);
if (mysql_real_connect(&my, "localhost", "root", "", "test", 0, NULL, 0)) {
printf("Connection success\n"); mysql_query(&my,"SET NAMES utf8");
char *querydata = "INSERT INTO MoneyDef(runcarid, costname, costcomment, money) VALUES ('5','xcf',CONVERT('洗车费' USING UTF8),'120')";
res = mysql_query(&my, querydata);插入正确但是
mysql> select * from MoneyDef;
+--------+----------+----------+-------------+-------+
| autoid | runcarid | costname | costcomment | money |
+--------+----------+----------+-------------+-------+
| 1 | 5 | xcf | laoliu | 120 |
| 2 | 5 | xcf | ??? | 120 |
+--------+----------+----------+-------------+-------+
2 rows in set (0.00 sec)
啥原因呢???郁闷中。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货