1,175 questions
1
vote
0
answers
50
views
Postgres Temp table collation for text columns
We are converting a large database system from SQL Server 2022 to Postgres 18.
The SQL Server collation is Latin1_General_CI_AS.
The Postgres database default collation is English_United Kingdom.1252.
...
- 43
8
votes
1
answer
163
views
Given various locales like "turkish", should a "\xFD" "nfinity" match "infinity" in strtod()?
Note that locales are a part of C that has evolving support.
Following is about C23 and maybe back to C99.
This is about an minor corner case in strtod().
With locales like "turkish", should ...
- 158k
1
vote
2
answers
72
views
Laravel case insensitive unique validation rule on multiple columns
I'm trying to validate a form, where there are two mandatory columns whose combination must be unique in the table. Validator should also ignore the case of the input.
$data = request()->validate([
...
2
votes
1
answer
113
views
Is it problematic to change the collation setting of only text columns without changing the database collation in PostgreSQL?
I am working with a PostgreSQL database and I need to change the collation setting of specific text columns. However, I do not want to alter the collation of the entire database.
The database ...
- 23
0
votes
0
answers
59
views
Python zipfile ExtractAll is not being case sensitive
I am making a Python code to unzip a .zip file and output the content into another.
The .zip file contains many files, some with case sensitive file names such as
T_N_with_client.docx
T_N_with_
lient....
- 1
1
vote
2
answers
208
views
How do I ignore case of double-dash options (long-options) in argparse?
I've written some command-line tools that have certain options having both single-dash-one-letter-abbreviations (short-options), as well as more verbosely named double-dash options (long-options) - as ...
- 43
0
votes
0
answers
47
views
Django query is case sensitive after moving to MariaDB
I have a Django project that can perform a query using a person's name as show in the attached code.
def get_queryset(self):
query = self.request.GET.get('query')
if query:
query = &...
0
votes
0
answers
79
views
How to Remove Case-Insensitive Repeated Words in a Sentence Using Regular Expressions?
Question details:
I'm solving the HackerRank Regex - Duplicate Words problem in Java where the goal is to use regular expressions to remove repeated words while retaining the first occurrence, ...
5
votes
1
answer
224
views
Case sensitive in VB.NET
I have a project in VB.NET where I have installed the Microsoft.Graph NuGet package (v5.58.0). This package contains two classes with nearly the same name, differing only by one capital letter: ...
- 1,832
0
votes
1
answer
58
views
Prevent Dictionary Key from changing the case in the output [closed]
I have this code to generate the output shown below, when I debug the code, I can see the "CostLine.ExternalId" but when the result is shown in Postman, the case has changed to "...
- 359
0
votes
0
answers
45
views
Lua: Assistance Needed in Using Inheritance in conjunction with case-insensitive metatables/metamethods? Doable?
I've been trying to wrap my head around utilizing inheritance with Lua (https://www.lua.org/pil/16.2.html and Case insensitive array in Lua as references) but also integrating a case-insensitive ...
0
votes
0
answers
177
views
Is there a replacement for PRAGMA case_sensitive_like?
SQLite Release 3.44.0 On 2023-11-01 states:
The PRAGMA case_sensitive_like statement is deprecated, as its use when the schema contains LIKE operators can lead to reports of database corruption by ...
- 1,147
0
votes
1
answer
113
views
How to Create a Case-Insensitive Unique Compound Index in MongoDB?
How to Create a Case-Insensitive Unique Compound Index in MongoDB?
Question Body:
I'm trying to create a compound unique text index in MongoDB with the following fields:
tenant_id: 1
seller_id: 1
...
- 61
5
votes
5
answers
335
views
Regex case-insensitive search, but have output match the case in the regex
Recently I rewrote my program to find English words that are made of chemical symbol abbreviations, for example "HErSHeY". I came up with this dynamic regex:
grep -Pi "^($(paste -s -d'|'...
- 11.5k
1
vote
3
answers
190
views
Case-insensitive map key where key is Pair<String, String> [closed]
I have Map in Java:
Map<Pair<String, String>, MyClass> myMap;
I need the Pair to NOT be case-sensitive. The solution in case of regular string key is simple:
TreeMap<String, MyClass&...
- 1,098
-1
votes
2
answers
1k
views
Case Insensitive Search on Git log comments
I use 'git log' and search for any comments by backslash / and typing the search text.
Using this I cannot do case insensitive search. For example vi we can use ':set ic' and do the search. But in '...
- 523
0
votes
2
answers
104
views
How can I make user entries case-insensitive in Python 3? [duplicate]
I am following FreeCodeCamp's Python tutorial. I would like to know how I can make user entries case-insensitive.
Here is the example code.
month_conversions = {
"Jan": "January&...
0
votes
0
answers
446
views
EF Setup database type of In-Memory database
Is it possible to setup type of in-memory database by Entity Framework? I need this In-Memory database correctly to be as Oracle SQL.
var options = new DbContextOptionsBuilder<MyDbContext>()....
- 189
0
votes
1
answer
97
views
How to perform case insensitive string-matching python 3.10? [duplicate]
I am trying to run a case statement from python version 3.10+ where a user should type the word 'add' as an input. However, if the user uses a capital letter like 'Add', it does not work.
todos = []
...
-1
votes
1
answer
54
views
Javscript Switch expression - How can it be made case insensitive?
I have two geojson files with the same key/labels but have different cases:
feature.properties.STATUS and feature.properties.status
I wish to test both file's label's values with a single switch ...
- 285
-1
votes
1
answer
270
views
Why when my python code writes files, it seems case-insensitive?
I have a dictionary and want to write the values to files whose names are based on the keys. My keys can be very similar, a letter can be upper or lower case.
dict_1 = {'g.XXXXX': '>g|XXXXX|1\...
- 27
2
votes
0
answers
604
views
C# MongoDB Case Insensitive Property
Is it possible to set the property names to be case insensitive when filtering?
In my case, I am dynamically getting a document. Let's say I am searching the users collection by first name. In ...
- 8,380
2
votes
0
answers
62
views
How can I convert the film_name parameter to lowercase using the lower() method in Python?
I want to convert the film_name parameter to lowercase using the lower() method. This ensures that the function can perform a case-insensitive search when checking if the film is a winner.
I tried the ...
- 21
1
vote
3
answers
92
views
C# - Case Insensitive Regex.Replace function with dictionaries
I have a sentence like this My name is [name] and I'm [age] years old
I would like to replace the text inside of square brackets with something belonging to a dictionary. I googled a bit and I've ...
- 41
0
votes
3
answers
1k
views
Case insesitive regex match with GoogleTest's regex matchers?
Question
I am looking for how to make a regular expression case insensitive, that works with GoogleTest's regex matchers (e.g. ContainsRegex).
I have tried unsuccessfully to prefix my expressions with ...
- 510
0
votes
1
answer
50
views
JS bug: highlight words, insensitive
It easily highlight words, framework free, case insensitive, even on html tagged code.
Could help improve that Pure JavaScript code?
Works, almost perfectly.
(document.body).realcar("word high&...
- 312
1
vote
3
answers
380
views
How to use case-agnostic-string-matching-condition in a Python list comprehension? [duplicate]
Is there a way to make a list comprehension to search for a string being case insensitive?
What I do now, which is subpar is:
original_list = ['NAME', 'NUMBER', 'name', 'number', 'Name', 'NaMe', '...
- 63
1
vote
2
answers
83
views
Set ArangoDB to be case insensitive
I want to know if there is a way to set the entire database, or at least the collections, to be case insensitive without having to use lower() or upper() in the queries.
0
votes
0
answers
30
views
Is there way to use PostgreSQL expression index with starting wildcard? [duplicate]
Using PostgreSQL, EntityFramework, C#.
My index was created by:
CREATE UNIQUE INDEX "IX_MyObjects_MyColumn"
ON "Manufacturing"."MyObjects" USING btree
(LOWER("...
- 65
0
votes
0
answers
90
views
Using InStr() in VBA to flag emails
I'm trying to make a macro that will go through a list of emails and flag potential problems by changing their color.
I was trying to do it by using the Like function, but I forgot that it's case ...
- 45
-1
votes
1
answer
162
views
Python case insensitive efficiently check if list of strings is contained in another string
I want to check if a list of string is contained in another string but ignoring the case
For example:
Input: 'Hello World', ['he', 'o w']
Output: [True, True]
Input: 'Hello World', ['he', 'wol']
...
- 651
0
votes
1
answer
203
views
Case-insensitive search of an object with jq
When retrieving an object from an array with jq in a JSON file like this
[
{
"field1": "Object1_Value1",
"field2": "Object1_Value2",
"field3&...
- 792
0
votes
1
answer
111
views
Django 3.2 CITEXT and unique_together
I'm using Django 3.2 and postgreSql 12.
I've added a new text field that should be case-insensitive, i.e if the value 'ab' exists, I want the DB to fail the request if someone is inserting 'Ab'. But ...
- 2,801
1
vote
1
answer
376
views
Mysql / Maria DB case (in)sensitive search
I am running 2 servers - Maria DB v10 on my Mac and MySQL v5.6 on Centos. Both of them have the same databases and behaviour is the same on both, so my problem is not related to OS or server version.
...
- 918
1
vote
1
answer
608
views
Powershell case insensitive dictionary [duplicate]
I retrieved a list of all Azure resources using Get-AzResource and stored one sample record in $Item. I am trying to get all of our tags for every resource, but the capitalization of the Key is ...
- 301
0
votes
1
answer
423
views
Switch to case insensitive in POSIX compliant shell script?
I'm translating a Windows-batch script to a Linux-shell script. This script is responsible for copying hundreds of different files from many unique locations to many unique locations. I've the problem ...
- 790
0
votes
1
answer
102
views
How to make statement case insensitive when uploading a dta file with specified columns?
I want to loop through different files:
forvalues y=2014/2022 {
use var1 var2 var3 using "file_`y'.dta"
save "file2_`y'
}
However, some of the files have var names VAR1 VAR2 ...
- 493
-1
votes
1
answer
74
views
Python Regex to Capture Proceeding Text - mixing cas insensitivity in group
Example Link
RegEx Group returning issue:
(?P<qa_type>(Q|A|Mr[\.|:]? [a-z]+|Mrs[\.|:]? [a-z]+|Ms[\.|:]? [a-z]+|Miss[\.|:]? [a-z]+|Dr[\.|:]? [a-z]+))?([\.|:|\s]+)?
Objective:
To extract text ...
- 13
-2
votes
1
answer
353
views
Reverse substring match in jq array
Let's say I have an array from file /some/file.json:
[
"This.FilE",
"That.file",
"Another.FIle"
]
Then I have a string x with value ThiS.FIle.is.HeRe, now I ...
- 1,139
0
votes
2
answers
358
views
Python: How to remove/discard a string from a set of strings using case-insensitive match?
I have a case from Wikidata where the string Articles containing video clips shows up in a set of categories and needs to be removed. Trouble is, it also shows up in other sets as articles containing ...
- 3
1
vote
1
answer
319
views
NGINX location case insensitive
I'm setting up a multisite web server with nginx, but I'm having a problem with managing subsites.
In practice, if I call up my web server with the url http://host/bollettini I can navigate the site ...
2
votes
1
answer
545
views
Case_insensitive not working on wildcard field type with cyrilic data
When you have an index with field that its type is wildcard and its filled with Cyrillic data and then when you perform wildcard query with case_insensitive: true, no documents are found.
Note: this ...
- 21
0
votes
1
answer
196
views
How to make gfortran case insensitive for reading filenames
I am new to gfortran, and I am trying to compile an atmospheric code that draws from numerous different files. The issue, however, is that some of the files used for input parameters are in different ...
- 23
1
vote
2
answers
229
views
Pandas Dataframe groupby on 3 columns and make one column lowercase
I have a dataframe:
country rating owner
0 England a John Smith
1 England b John Smith
2 France a Frank Foo
3 France a Frank foo
4 France a ...
- 41
0
votes
1
answer
155
views
How do I ask git to clean out and rebuild the entire working tree?
We have something of an ugly mess that needs cleaning up.
In our codebase, certain developers created directories whose name differed only in case. Normally, such a thing would not be an issue; ...
- 43.6k
0
votes
1
answer
554
views
Adding COLLATION in postgres
I am migrating data from SQL Server to Postgres. Since Postgres is case-sensitive, I am trying to add case-insensitive COLLATION but it is failing with the below error -
ERROR: could not create ...
- 33
0
votes
1
answer
54
views
How to do case insensitive search in StringOperators.valueOf("field1").indexOf(txtSchStr))
I have a springdata mongodb aggregation where I use
agg = Aggregation.newAggregation(BrkrBean.class, match(criteria),
project("productId, "fullName").and(
StringOperators....
- 698
1
vote
1
answer
2k
views
Case insensitive access of JSON keys
I am trying to update json(depth > 2) file using Newtonsoft library. While reading the file, if json keys case are not same as in json file, it failed to fetch its value.
Sample JSON file:
{
&...
- 1,089
3
votes
3
answers
364
views
Sort a list in Python, ignore blanks and case
I have a list (of dictionary keys), which I need to sort. This is my list:
listToBeSorted = ["Right Coronary Artery 2", "Right Coronary Artery 1", "RIght Coronary Artery 3&...
- 31
1
vote
1
answer
216
views
How to do case-insensitive comparison in delete() method of SQLiteDatabase class Android
I am making an Android app in Kotlin with SQLite, and I use the code below to delete a record with 'subject' column.
val rows = db.delete(TABLE_NAME, "subject=?", arrayOf(subject))
It works ...
- 87