关于MYSQL数据保存用utf8编码保存,有的数据搜索不到
Jun 23, 2016 pm 02:24 PM 我的网页用的是utf8编码,所以在保存数据时加入了mysql_query("set names 'utf-8'");
mysql整理成了utf8_general_ci
而我在搜索数据时
$so="爱你一万年";
movie` WHERE `a0` LIKE '%$so%' AND `a2` LIKE '%$so%' LIMIT 0 , 1200
这样搜索中文变量时,有的中文传递过来的变量,根本搜索不出来。
回复讨论(解决方案)
$so用单引号不会解析变量,因为这个?
搜索的时候加了 set names utf8 没有?
$so用单引号不会解析变量,因为这个?
这个应该是正解

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

11 Best PHP URL Shortener Scripts (Free and Premium)

Working with Flash Session Data in Laravel

Build a React App With a Laravel Back End: Part 2, React

Simplified HTTP Response Mocking in Laravel Tests

cURL in PHP: How to Use the PHP cURL Extension in REST APIs

12 Best PHP Chat Scripts on CodeCanyon

Announcement of 2025 PHP Situation Survey
