Dreamweaver中应用mysql语句遇到的问题

我在Dreamweaver中新建一个php文件saveaddleibie.php。代码如下:
<?php
include("conn/conn.php");
mysql_query("insert into tb_type(id,typename) values ('3','机械')",$conn);
?>
当然conn文件夹下的conn.php文件也写好。用DW打开saveaddleibie.php,按F12运行后,应该向数据库的tb_type表中插入数据。但结果令人无解,只插入成功'id'列的3,
'typename'列的'机械'没插入成功。具体看命令行的查询。如下图:
图片说明
但我在命令行中输入语句insert into tb_type(id,typename) values ('3','机械')后,
两列都能正常插入。请各位大神,我该怎么办才能在用DW的方式正常插入两列数据呢?

汉字得编码在php中估计有问题。

个人觉得不至于一列成功一列不成功的情况
1、检查一下是不是后面有update操作,把另一个字段置空了
2、配置一下mysql日志,把执行的SQL记录下来,执行一次,查一下sql记录

我是提问者,根据回答者的提示,我配置了一下mysql日志,再在DW中按F12,执行一次插入,查看一下sql记录,还没找到原因。具体mysql日志如下:
MySQL, Version: 5.6.22-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
150417 19:05:39 1 Connect root@localhost on
1 Query SET CHARACTER SET 'utf8mb4'
1 Query SET collation_connection = 'utf8mb4_unicode_ci'
1 Query SHOW TABLES FROM db_shop
1 Init DB db_shop
1 Query SELECT DATABASE()
1 Init DB db_shop
1 Query SELECT * FROM tb_type
LIMIT 0, 25
1 Query SELECT TABLE_NAME
FROM information_schema.VIEWS
WHERE TABLE_SCHEMA = 'db_shop'
AND TABLE_NAME = 'tb_type'
1 Query SELECT ,
TABLE_SCHEMA AS Db,
TABLE_NAME AS Name,
TABLE_TYPE AS TABLE_TYPE,
ENGINE AS Engine,
ENGINE AS Type,
VERSION AS Version,
ROW_FORMAT AS Row_format,
TABLE_ROWS AS Rows,
AVG_ROW_LENGTH AS Avg_row_length,
DATA_LENGTH AS Data_length,
MAX_DATA_LENGTH AS Max_data_length,
INDEX_LENGTH AS Index_length,
DATA_FREE AS Data_free,
AUTO_INCREMENT AS Auto_increment,
CREATE_TIME AS Create_time,
UPDATE_TIME AS Update_time,
CHECK_TIME AS Check_time,
TABLE_COLLATION AS Collation,
CHECKSUM AS Checksum,
CREATE_OPTIONS AS Create_options,
TABLE_COMMENT AS Comment
FROM information_schema.TABLES t
WHERE TABLE_SCHEMA
IN ('db_shop')
AND t.TABLE_NAME = 'tb_type' ORDER BY Name ASC
1 Query SELECT COUNT(
) FROM db_shop.tb_type
1 Query SELECT TABLE_NAME
FROM information_schema.VIEWS
WHERE TABLE_SCHEMA = 'db_shop'
AND TABLE_NAME = 'tb_type'
AND IS_UPDATABLE = 'YES'
1 Query SHOW INDEXES FROM db_shop.tb_type
1 Query SHOW CREATE TABLE db_shop.tb_type
1 Query SHOW FULL COLUMNS FROM db_shop.tb_type
1 Query SHOW COLUMNS FROM db_shop.tb_type
1 Query SELECT CURRENT_USER()
1 Query SELECT PRIVILEGE_TYPE FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
1 Init DB db_shop
1 Quit

2 Connect root@localhost on
2 Query SET CHARACTER SET 'utf8mb4'
2 Query SET collation_connection = 'utf8mb4_unicode_ci'
2 Quit

150417 19:05:46 3 Connect root@localhost on
3 Init DB db_shop
3 Query set character set gb2312
3 Query set names gb2312
3 Query insert into tb_type(id,typename) values ('3','机械')
3 Quit

150417 19:05:57 4 Connect root@localhost on
4 Query SET CHARACTER SET 'utf8mb4'
4 Query SET collation_connection = 'utf8mb4_unicode_ci'
4 Query SHOW TABLES FROM db_shop
4 Init DB db_shop
4 Query SELECT DATABASE()
4 Init DB db_shop
4 Query SELECT * FROM tb_type
LIMIT 0, 25
4 Query SELECT TABLE_NAME
FROM information_schema.VIEWS
WHERE TABLE_SCHEMA = 'db_shop'
AND TABLE_NAME = 'tb_type'
4 Query SELECT ,
TABLE_SCHEMA AS Db,
TABLE_NAME AS Name,
TABLE_TYPE AS TABLE_TYPE,
ENGINE AS Engine,
ENGINE AS Type,
VERSION AS Version,
ROW_FORMAT AS Row_format,
TABLE_ROWS AS Rows,
AVG_ROW_LENGTH AS Avg_row_length,
DATA_LENGTH AS Data_length,
MAX_DATA_LENGTH AS Max_data_length,
INDEX_LENGTH AS Index_length,
DATA_FREE AS Data_free,
AUTO_INCREMENT AS Auto_increment,
CREATE_TIME AS Create_time,
UPDATE_TIME AS Update_time,
CHECK_TIME AS Check_time,
TABLE_COLLATION AS Collation,
CHECKSUM AS Checksum,
CREATE_OPTIONS AS Create_options,
TABLE_COMMENT AS Comment
FROM information_schema.TABLES t
WHERE TABLE_SCHEMA
IN ('db_shop')
AND t.TABLE_NAME = 'tb_type' ORDER BY Name ASC
4 Query SELECT COUNT(
) FROM db_shop.tb_type
4 Query SELECT TABLE_NAME
FROM information_schema.VIEWS
WHERE TABLE_SCHEMA = 'db_shop'
AND TABLE_NAME = 'tb_type'
AND IS_UPDATABLE = 'YES'
4 Query SHOW INDEXES FROM db_shop.tb_type
4 Query SHOW CREATE TABLE db_shop.tb_type
4 Query SHOW FULL COLUMNS FROM db_shop.tb_type
4 Query SHOW COLUMNS FROM db_shop.tb_type
4 Query SELECT CURRENT_USER()
4 Query SELECT PRIVILEGE_TYPE FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
4 Init DB db_shop
4 Quit

5 Connect root@localhost on
5 Query SET CHARACTER SET 'utf8mb4'
5 Query SET collation_connection = 'utf8mb4_unicode_ci'
5 Quit

请问各位大神是什么原因呢?