Questions tagged [accent-insensitive]

Collation which considers the accented and unaccented versions of letters to be identical for sorting purposes.

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'…
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…
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:…
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,…
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",, } ) …
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…
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