求字符集解决方案，顽固性的~
+--------------------------+--------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | E:\xampp\mysql\share\charsets\ |
+--------------------------+--------------------------------+
*************************** 1. row ***************************
goods_id: 1
goods_name: R510VC 15.6?????
goods_cate: ???
brand_name: ??
goods_price: 3399.000
is_show: 1
is_saleoff: 0
charset utf8set names utf8; // utf8 gbk 都试过简直就是顽固性啊。
使用这样的建表语句
CREATE TABLE IF NOT EXISTS tdb_goods(
goods_id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
goods_name VARCHAR(150) NOT NULL,
goods_cate VARCHAR(40) NOT NULL,
brand_name VARCHAR(40) NOT NULL,
goods_price DECIMAL(15,3) UNSIGNED NOT NULL DEFAULT 0,
is_show BOOLEAN NOT NULL DEFAULT 1,
is_saleoff BOOLEAN NOT NULL DEFAULT 0
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
显示为这样
*************************** 1. row ***************************
goods_id: 1
goods_name: R510VC 15.6英å?笔è?æ
goods_cate: 笔è?æ
brand_name: 华ç?
goods_price: 3399.000
is_show: 1
is_saleoff: 0
1 row in set (0.00 sec)
