MySQL SELECT 查询不区分大小写吗? [英] Are MySQL SELECT queries case-insensitive?

问题描述

我有一个带有方法帖子的表单，用户将按品牌日期等过滤结果.如果 MySQL 中的品牌名称存储为非小写示例( samsung )并且搜索输入字段填充为大写示例( SAMSUNG )，它仍然会给我正确的结果还是会导致错误?

I have a form with method post, users will filter results by brand date etc. If the brand name in the MySQL is stored with non lowercase example ( samsung ) and the search input field is filled with uppercase example ( SAMSUNG ) will it still give me the correct results or will cause errors ?

$branded=mysqli_real_escape_string($db, $_GET['brand']); // USER TYPED SAMSUNG
}
$query= "SELECT * FROM `brands` WHERE `brand` = '$branded' LIMIT 1"; // stored as samsung

推荐答案

区域设置为latin1_swedish_ci".

The locale is "latin1_swedish_ci".

因为它以ci"结尾，所以它必须是case-insensitive.

Because it ends in "ci", it must be case-insensitive.

这篇关于MySQL SELECT 查询不区分大小写吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！