Collation which considers the accented and unaccented versions of letters to be identical for sorting purposes.
Questions tagged [accent-insensitive]
62 questions
1
vote
2 answers
OData accent-insensitive filter
How can I apply a filter accent-insensitive? In OData the "eq" operator is case and accent sensitive. The case is easy to fix, because the "tolower" but relative to the accent I'm not getting a simple solution. I know contains is supposed to be…

Tarsis F
- 51
- 3
1
vote
1 answer
Postgresql accent insensitive for non-accent and sensitive for accent word
In Postgresql how to achieve separate search result with and without accent using like/ilike, something like this:
The record names are: cafe, café, cafeteria
If I use select name from cafe-table where name like '%cafe%'; then the result will be…

Quang
- 135
- 2
- 9
1
vote
2 answers
MongoDB match partial text ignoring accents (diacritics)
I have two fields that I should match with simple text.
I'm currently using Jenssegers'Laravel Mongodb (https://github.com/jenssegers/laravel-mongodb)
The code right now is like this, and works almost as like I want:
$nameFilter = [[
'$match'…

Gregory Wullimann
- 528
- 5
- 22
1
vote
0 answers
Spring-boot + mongodb does not find word with accent
Good morning people,
I'm having trouble using MongoRepository with spring-boot,
I created my query interfaces to access mongodb collections, and the following situation is happening.
Ex: I have a Document with "title" attribute and its value…

Adriano Gomes
- 11
- 2
1
vote
0 answers
Solr schema. exact accented match and accent insensitive match
I'm trying to figure out how to configure the Solr manage-schema's fieldType to achieve the following:
(a) When searching for non-accented strings, the results will be accent insensitive.
(b) HOWEVER When performing searching on accented strings,…

setzuiro
- 427
- 5
- 13
1
vote
1 answer
How can I ignore accented characters when string matching in SPARQL
I have no idea to how to compare different labels without taking accents into account.
The next query doesn't return the place because "Ibáñez" has accents in Spanish DBpedia, but it has different accents in my data source.
PREFIX rdfs:…

Jesús Ibáñez
- 9
- 2
1
vote
2 answers
How do I perform an accent insensitive compare in SQL Server for 1250 codepage
There are already sever question and solution on accent insensitive search on stackoverflow, but none of them work for codepage 1250 (Central European and Eastern European languages).
How do I perform an accent insensitive compare (e with è, é, ê…

Tomas Kubes
- 23,880
- 18
- 111
- 148
1
vote
1 answer
c# How to filter Datagridview bind to dataset - Accent Insentitive
I have a DataGridView bind to a DataSet, some value (Name) have accent (ex: é, í, ž, ć, é, á) and I would to perform a filtering accent insensitive.
Usually I am filtering my DataGridView like this:
private void textBox1_TextChanged(object sender,…

KTG
- 53
- 3
1
vote
1 answer
SQL - Accented characters not updating
Hello everyone and welcome to my nightmare. I am preparing a database in order to run a number of SSIS packages to migrate the required data into a data warehouse.
I am in the process of updating customer names with accented characters to…

Will
- 228
- 1
- 2
- 15
1
vote
1 answer
SQL JOIN with two tables and with a condition for one table, in a single SQL statement
I have an sqlite database which has a table of documents (journal articles), where each document has a unique id. All the authors are listed in another table, with corresponding document id's, and with unique author id's as well. The problem is that…

Maximko
- 627
- 8
- 20
1
vote
0 answers
How to ignore accent using breeze local query?
I am using breeze to query data from local, but I have some problems to remove diacritics and query with accent insensitive. For example:
var name = 'HELEN';
var pred = new breeze.Predicate('name', breeze.FilterQueryOp.Contains,…

kuskunko
- 330
- 6
- 17
0
votes
0 answers
GraphQL.EntityFramework: override e.g. contains filter to do EF.Functions.Collate(..., "BINARY_AI")
Recently I did a POC with hotchocolate and I was able to override the query behaviour on the contains/like filter on strings so that I could do a case-insensitive and accent-insensitive search. I am looking for extension points in…

Anoo
- 1
- 1
0
votes
0 answers
API Netbox or pynetbox: how to pass accented characters without triggering Pynetbox.RequestError?
I try to send data from a French database to Netbox but spaces and accented characters trigger an error as in the example:
Post_dept = nb.dcim.sites.create([
{
"name":"Saône et Loire",
"slug":"saône et loire",,
}
) …

Airhmine
- 1
0
votes
0 answers
Is there any way to replace all greek letters with accents with the ones without? (the need is to handle an nlu problem with greek utterances)
I am currently building a chatbot for greek users and i need to avoid adding duplicate utterances for 'with' and 'without' accent cases so as to not have a heavy model.
Do you know if there is a way to replace the list of greek letters having accent…

Emma
- 11
- 1
0
votes
2 answers
How to make an accent insensitive `MATCH() AGAINST()` sentence?
I have a table called products which has a varchar column called name encoded in latin1_swedish_ci.
I'm trying to make a search query in order to filter products by name using the MATCH() AGAINST() sentence that look like this:
SELECT *
FROM…

AlexSp3
- 2,201
- 2
- 7
- 24