MySQL使用like查找汉字乱码

Posted on 2017-02-08 Edited on 2025-07-25 Symbols count in article: 134 Reading time ≈ 1 mins.

第一种解决办法：BINARY

在关键字之前加上：BINARY，会使关键字强制转换为二进制字符串

1	select id form t where chinese like BINARY %汉字%

把关键字的类型改成：BINARY

Post author: hisenyuan
Post link: http://hisen.me/20170208-MySQL使用like查找汉字乱码/
Copyright Notice: All articles in this blog are licensed under BY-NC-SA unless stating additionally.