我想查找字符串"JESÚS"
,但只返回具有指定字符串的文档,我需要忽略重音和大写字母进行搜索。
我正在使用C#和mongodb驱动程序。
我在我的mongodb中保存了两个文档:
_id:5d265f3129ea36365c7ca587
TRABAJADOR:"JESUS HERNANDEZ DIAZ"
_id:5d265f01db86a83148404711
TRABAJADOR:"JESÚS HERNÁNDEZ DÍAZ"
在使用Mongo驱动程序的Visual C#中:
var filter = Builders<BsonDocument>.Filter.Regex("TRABAJADOR", new BsonRegularExpression(string.Format(".*{0}.*", "JESÚS"), "i"));
var result = collection.Find(filter, new FindOptions() { Collation = new Collation("es", strength: CollationStrength.Primary, caseLevel:true) }).ToList();
output = JsonConvert.SerializeObject(result);
return output;
如果我搜索
"JESÚS"
,实际输出:_id:5d265f01db86a83148404711
TRABAJADOR:"JESÚS HERNÁNDEZ DÍAZ"
但实际上我期望的输出是:
_id:5d265f3129ea36365c7ca587
TRABAJADOR:"JESUS HERNANDEZ DIAZ"
_id:5d265f01db86a83148404711
TRABAJADOR:"JESÚS HERNÁNDEZ DÍAZ"