accent-insensitive Questions
2
Solved
Is there any way to do an accent-insensitive LIKE query in SQLite? For example, this query:
SELECT * FROM users WHERE name LIKE "Andre%"
would return:
André the Giant
Andre Agassi
etc.
I'm u...
Terbecki asked 23/12, 2012 at 6:59
3
Solved
In Python 3, I'd like to be able to use re.sub() in an "accent-insensitive" way, as we can do with the re.I flag for case-insensitive substitution.
Could be something like a re.IGNOREACCENTS flag:...
Linin asked 26/4, 2017 at 12:39
2
Solved
I am using this to sort according to last name:
usort($fb_friends['data'], "custom_sort");
function custom_sort($a, $b) {
return $a['last_name'] > $b['last_name'];
}
foreach ($fb_f...
Priggery asked 11/3, 2012 at 12:26
7
I'm looking to query a database of wine names, many of which contain accents (but not in a uniform way, and so similar wines may be entered with or without accents)
The basic query looks like this...
Fernandafernande asked 3/1, 2013 at 10:43
1
Solved
I use PostgreSQL 10 and I run CREATE EXTENSION unaccent; succesfully. I have a plgsql function that contains the following
whereText := 'lower(unaccent(place.name)) LIKE lower(unaccent($1))';
late...
Phonation asked 15/4, 2018 at 17:54
8
Solved
When using jQuery DataTables is it possible to do accent-insensitive searches when using the filter? For instance, when I put the 'e' character, I'd like to search every word with 'e' or 'é', 'è'.
...
Windpollinated asked 17/2, 2014 at 15:55
1
Solved
I have a document collection with following structure
uid, name
With a Index
db.Collection.createIndex({name: "text"})
It contains following data
1, iphone
2, iphóne
3, iphonë
4, iphónë
W...
Fosque asked 31/3, 2017 at 10:15
1
I am using bootstrap-select for a form using data-live-search enabled, so that the user can both type the search term and find it in the dropdown. The dropdown list, however, has some terms with ac...
Practical asked 1/11, 2015 at 17:58
2
Solved
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 us...
Mclain asked 15/11, 2015 at 16:41
1
Solved
I'm putting together some tables that look almost the same, except that some characters appear accented in some and non-accented in others. For instance, "André" sometimes reads "Andre", "Flávio" a...
Energid asked 12/8, 2015 at 18:42
2
Solved
I would like to know if there is a method that compares 2 strings and ignores the accents making "noção" equal to "nocao".
it would be something like string1.methodCompareIgnoreAccent(string2...
Pettway asked 3/3, 2015 at 14:4
2
Solved
How to compare strings with case insensitive and accent insensitive
Alright this is done easily at SQL server
However I would like to do the same at C# .NET 4.5.1.
How can I do that with most pr...
Illona asked 12/1, 2015 at 13:51
2
Solved
I have a dataset which mixes use of unicode characters \u0421, 'С' and \u0043, 'C'. Is there some sort of unicode comparison which considers those two characters the same? So far I've tried several...
Unexpected asked 14/10, 2013 at 0:0
2
Solved
I need to compare 2 strings as equal such as these:
Lubeck == Lübeck
In JavaScript.
Why? Well, I have an auto-completion field that's going out to a Java service using Lucene, where place nam...
Savick asked 22/10, 2008 at 23:48
1
© 2022 - 2024 — McMap. All rights reserved.