mysql where查询中文问题

Question

SELECT * FROM detail WHERE  dafenleidetail='牛副产品'
只能查询出1条记录 其他都查询不出来了 而且并没有报错这个是为什么呢

Answer 1

select hex(dafenleidetail) FROM detail 
贴结果

Answer 2

select  hex(dafenleidetail) from tb看看那几个牛副产品的十六进制码是否相同

Answer 3

 hex(dafenleidetail)
E7899BE589AFE4BAA7E59381
E7899BE589AFE4BAA7E593810D0A
E7899BE589AFE4BAA7E593810D0A
E7899BE589AFE4BAA7E593810D0A

Answer 4

show variables like 'char%'; 
show create table detail ;

Answer 5

Variable_name  Value
character_set_client  utf8
character_set_connection  utf8
character_set_database  latin1
character_set_filesystem  binary
character_set_results  utf8
character_set_server  latin1
character_set_system  utf8
character_sets_dir  e:\wamp\bin\mysql\mysql5.5.24\share\charsets\我这算字符编码相同吗

Answer 6

character_set_database  latin1
character_set_server  latin1
这2个是什么

Answer 7

set names utf8;
show variables like 'char%'; 看看与你的结果有无差别

Answer 8

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 D:\\MySQL55\\share\\charsets\\

Answer 9

可能有空格，这样写应该可以：
SELECT * FROM detail WHERE  ALLTRIM(dafenleidetail)='牛副产品'

Answer 10

SELECT * FROM detail WHERE  ALLTRIM(dafenleidetail)='牛副产品'
报错。。#1305 - FUNCTION ruixiang.ALLTRIM does not exist

Answer 11

character_set_server=utf8 这个怎么改啊 我该了半天也不行

Answer 12

set names utf8;
 show variables like 'char%'; 

Answer 13

你是怎么修改的？
MYSQL 5.5
在MY。INI中
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
重新启动MYSQL

Answer 14

哇 好厉害 一改成就成功
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:\wamp\bin\mysql\mysql5.5.24\share\charsets\
完美的UTF8

Answer 15

这个是sql下载地址http://pan.baidu.com/share/link?shareid=377773&uk=3238029663
你试试吧
导出sql 导入 还是没用

Answer 16

Variable_name  Value
character_set_client  utf8
character_set_connection  utf8
character_set_database  latin1
character_set_filesystem  binary
character_set_results  utf8
character_set_server  latin1
character_set_system  utf8
character_sets_dir  e:\wamp\bin\mysql\mysql5.5.24\share\charsets\