如何在 NDB/DB 查询中忽略大小写

本文介绍了如何在 NDB/DB 查询中忽略大小写的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

限时送ChatGPT账号..

这似乎是一个简单的问题，但我在 类定义.

This seems like a simple question, but I don't see anything in the class definition.

如果我有查询

Video.query(Video.tags.IN(topics))

topics 以小写的 unicode 字符串形式出现，但 Video.tags 大部分是大写的.我可以遍历 topics 并在查询它们之前将它们大写，但是有没有办法完全忽略大小写?

topics are coming in as lowercase unicode strings, but Video.tags are mostly capitalized. I can loop through topics and capitalize them before querying with them, but is there a way to ignore case altogether?

推荐答案

在查询中不能忽略大小写.

It's not possible to ignore case in a query.

通常，如果您知道要进行不区分大小写的搜索，您可以以小写形式存储数据的非规范化"副本.每当您要查询时，您都会在查询前将文本小写.

Typically if you know you want to do a case insensitive search, you may store a "denormalized" duplicate of the data in lower case. Whenever you want to query, you would lowercase the text before querying.

为了降低写入成本，您可能只想索引小写版本，而您可能不需要索引实际区分大小写的数据.

To reduce write costs, you probably only want to index the lowercased version, and you probably wouldn't need to index the actual case-sensitive data.

这篇关于如何在 NDB/DB 查询中忽略大小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！