Stack Overflow
Stack Overflow

Questions tagged [accent-insensitive]

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

62 questions
4
votes
1 answer

Java remove punctuation on a String (also ’ “ ” and all of these) maintaining accents characters

I need to remove punctuation reading on a file, maintaining accents character I tried this code but don't work how I would. Expectation: input=> ’'qwe..,rty ‘èeéò’“ ”o" "à output=> qwertyèeéòoà Effective result: input=> ’'qwe..,rty ‘èeéò’“ ”o"…
Giammarco
  • 43
  • 7
4
votes
2 answers

JPA CriteriaQuery - accent insensitive

I am using JPA and PostgreSQL and I want to create a CriteriaQuery and create a query where the accents are not taken into consideration. Example: if I search the letter 'a', the database should return the values 'ã', 'a', 'á', etc. This should…
henriquels
  • 518
  • 4
  • 20
4
votes
2 answers

Make jquery :Contains accent insensitive

I have this case insensitive custom selector : jQuery.expr[':'].Contains = function(a,i,m) { var text = jQuery(a).text().toUpperCase(); var words = m[3].split(/\s+/); for(var i = 0; i < words.length; i++) { if (-1 ==…
morgi
  • 1,005
  • 3
  • 17
  • 24
3
votes
1 answer

How to make an accent insensitive palindrome checker in MIPS?

I am writing a palindrome checker in MIPS, and I was trying to make it accent insensitive so that something like "ahà" would be considered a palindrome too. However, it doesn't look so simple as the case insensitive scenario where there is a fixed…
spiky
  • 31
  • 2
3
votes
2 answers

How to search string using Entity Framework with .Contains and with accent-insensitive

In my database, I have a table that stores cities. Some cities have accents like "Foz do Iguaçu". In my MVC application, I have a JSON that return a list of cities based in a word, however, few users aren't using accents to search for the city, for…
Dan
  • 1,518
  • 5
  • 20
  • 48
3
votes
2 answers

jQuery DataTables not working special characters results in search

I am trying to search some words with special characters in jQuery Datatables plugin. There are some results in datatable like this: Peinado, Alma_María Aguilar Castillo, Antonio José When I try to search "alma_maría", the first result is…
joan16v
  • 5,055
  • 4
  • 49
  • 49
3
votes
2 answers

Search without accents must return words with accents

I have a web app developed with Hibernate, Spring and Java, that accesses an Informix database... Imagine you are searching for a certain record with an accent on it, like "María", but you write "Maria" in the search box... now it doesn't show any…
diminuta
  • 1,545
  • 8
  • 32
  • 55
2
votes
1 answer

Lucene.net 4.8 unable to search with accent

based on some help here in stack overflow I managed to create a custom analyzer, but still cant work around search where a word has an accent. public class CustomAnalyzer : Analyzer { LuceneVersion matchVersion; public…
diegoarg79
  • 111
  • 1
  • 6
2
votes
1 answer

Remove Diacritics from string in Snowflake

I would like to remove all diacritics from a string column, using Snowflake SQL. For example: ä, ö, é, č => a, o e, c I acknowledged that the TRANSLATE function would work but only for single case while there are lots of letters with an accent that…
Hạnh Do Duc
  • 45
  • 4
2
votes
2 answers

Yii2: accent insensitive filter

I want to search words using accent insensitive. For case insensitive I use ilike: $query->andFilterWhere(['ilike', 'name', $this->name]); But for accent insensitive I don't know a Yii2 solution (else I can use this PHP solution). In the next…
Roby Sottini
  • 2,117
  • 6
  • 48
  • 88
2
votes
1 answer

How to handle accents characters in Spanish websites in Mura

The issue I am encountering is when a user is on the Spanish website, they are not able to see all results if their type the word incorrectly. Meaning, if their character does not have the accent above the character, the results will show blank. For…
user9808783
  • 129
  • 11
2
votes
0 answers

Letter with accent is not appearing properly in my Rails console, Postgres database or Webpage

I have a Microsoft Excel file (saved as a CSV file) that contains a list of names. A few of the names have letters with an accent over it, like so: Maria Vásquez In my seed file, I parse the CSV file to create Person instances, like…
Diana E.
  • 309
  • 5
  • 11
2
votes
2 answers

Accent Insensitive query in Neo4J

It is very easy to do case insensitive Cypher queries. I am now trying to figure out if there is an easy way to make Accent Insensitive queries. I am thinking of a query similar to : MATCH n:City WHERE n.Name =~ '(?a)Montreal' RETURN n Is someone…
Martin Larivière
  • 264
  • 1
  • 10
2
votes
1 answer

Use of sqlite3_create_collation on iPhone

I would like to create a collation in order to make case insensitive and no accents searches in a database. here is my code : static int sqlite3NoCaseNoAccentCollate(void * foo, int ll, const void *l, int rl, const void…
djleop
  • 687
  • 4
  • 18
1
vote
1 answer

SQL Server Collation Setting

In the SQL server, the default collation is SQL_Latin1_General_CP1_CI_AS, previously, I used to specify the collation explicitly at the end of each query to SQL_Latin1_General_CP1_CI_AI to ignore the accents when comparing strings. Now, I wanted to…
Ⲁⲅⲅⲉⲗⲟⲥ
  • 608
  • 1
  • 8
  • 31
1
2
3 4 5