blocks|key|1272694|text|你用的是什么数据库？对于MS+SQL+Server，它是一个数据库范围的设置，或者您可以使用COLLATE关键字覆盖每个查询的设置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1272695|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

What database are you on? With MS SQL Server, it's a database-wide setting, or you can over-ride it per-query with the COLLATE keyword.

blocks|key|1487362|text|通常，字符串比较是不区分大小写的。如果您的数据库配置为区分大小写，则需要强制使用不区分大小写的排序规则：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1487363|SELECT+balance+FROM+people+WHERE+email+=+'billg@microsoft.com'
++COLLATE+SQL_Latin1_General_CP1_CI_AS+|code-block|syntax|javascript|1487364|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Usually, string comparisons are case-insensitive. If your database is configured to case sensitive collation, you need to force to use a case insensitive one:

<pre><code>SELECT balance FROM people WHERE email = 'billg@microsoft.com'
 COLLATE SQL_Latin1_General_CP1_CI_AS 
</code></pre>

blocks|key|1487413|text|您可以强制区分大小写，像这样强制转换为varbinary：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1487414|SELECT+*+FROM+myTable+
WHERE+convert(varbinary,+myField)+=+convert(varbinary,+'sOmeVal')|code-block|syntax|javascript|1487415|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can force the case sensitive, casting to a varbinary like that:

<pre><code>SELECT * FROM myTable 
WHERE convert(varbinary, myField) = convert(varbinary, 'sOmeVal')
</code></pre>

blocks|key|1272845|text|我在别处找到了另一种解决方案，即使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1272846|upper(@yourString)|code-block|syntax|javascript|1272847|但是这里的每个人都在说，在SQL+Server中，这无关紧要，因为它忽略了大小写？我很确定我们的数据库是区分大小写的。|1272848|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I found another solution elsewhere; that is, to use

<pre><code>upper(@yourString)
</code></pre>

but everyone here is saying that, in SQL Server, it doesn't matter because it's ignoring case anyway? I'm pretty sure our database is case-sensitive.

blocks|key|1272919|text|不能，只使用LIKE是行不通的。LIKE搜索与给定模式完全匹配的值。在这种情况下，LIKE将只找到文本'someval‘，而不是'sOmeVal’。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1272920|一种可行的解决方案是使用LCASE()函数。LCASE('sOmeVal')获取文本的小写字符串：“someval”。如果您在比较的两边都使用此函数，它将起作用：|1272921|SELECT+*+FROM+myTable+WHERE+LCASE(myField)+LIKE+LCASE('sOmeVal')|1272922|该语句将比较两个小写字符串，以便您的'sOmeVal‘将匹配所有其他表示法'someval’(例如：'Someval'，'sOMEVAl‘等)。|1272923|entityMap^0|6|4|G|4|15|4|0|C|7|M|G|0|0|1S|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|12|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|M|$]]

No, only using <code>LIKE</code> will not work. <code>LIKE</code> searches values matching exactly your given pattern. In this case <code>LIKE</code> would find only the text 'sOmeVal' and not 'someval'.

A pracitcable solution is using the <code>LCASE()</code> function. <code>LCASE('sOmeVal')</code> gets the lowercase string of your text: 'someval'. If you use this function for both sides of your comparison, it works:

<code>SELECT * FROM myTable WHERE LCASE(myField) LIKE LCASE('sOmeVal')</code>

The statement compares two lowercase strings, so that your 'sOmeVal' will match every other notation of 'someval' (e.g. 'Someval', 'sOMEVAl' etc.).

How do I construct a SQL query (MS SQL Server) where the "where" clause is case-insensitive?

<pre><code>SELECT * FROM myTable WHERE myField = 'sOmeVal'
</code></pre>

I want the results to come back ignoring the case

SQL server ignore case in a where expression

SQL Server

数据库

如何构造" where“子句不区分大小写的SQL查询(MS SQL Server)？SELECT * FROM myTable WHERE myField = 'sOmeVal'我想让结果出来而不管这个案子

问SQL server忽略where表达式中的大小写
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL server忽略where表达式中的大小写EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL server忽略where表达式中的大小写
EN