We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
mysql 搜索是不区分大小写的, 切到postgres发现搜索区分了大小写.
var/Widget/Archive.php的搜索 和 admin 里的搜索, 是不是调整下Pgsql的判断, 比如
$adapterName = $this->db->getAdapterName(); if (strpos($adapterName, 'Pgsql')) { $select->where('table.contents.title ~~* ? OR table.contents.text ~~* ?', $searchQuery, $searchQuery) ->where('table.contents.type = ?', 'post'); } else { $select->where('table.contents.title LIKE ? OR table.contents.text LIKE ?', $searchQuery, $searchQuery) ->where('table.contents.type = ?', 'post'); }
The text was updated successfully, but these errors were encountered:
确实有这个问题,不过这么改有点丑,我得想一个更好的解决方法
Sorry, something went wrong.
c66b6e2
No branches or pull requests
mysql 搜索是不区分大小写的, 切到postgres发现搜索区分了大小写.
var/Widget/Archive.php的搜索 和 admin 里的搜索, 是不是调整下Pgsql的判断, 比如
The text was updated successfully, but these errors were encountered: