Skip to main content

Questions tagged [case-sensitive]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
14 views

MySQL case sensitivity setting

Does anyone know the file name or path where I can change the lower_case_tables_names value on the latest version of MySQL Windows 11?
Tubatse Katlego Moloi's user avatar
0 votes
0 answers
56 views

How can I make a foreign-key case-insensitive in Postgresql?

I have a Mariab-database using collation utf8bm4_general_ci and I am migrating to Postgresql. Some tables are foreign keyed using case-insensitive strings (e-mails sourced from different systems). ...
jared's user avatar
  • 123
0 votes
0 answers
581 views

PostgreSQL lower case or remove double quotes on every table name before select query

We are migrating from OracleDB to PostgreSQL and all the tables name in database are lower case while the script from application is mixed with double quotes. For example the code in application like ...
Entaah Laah's user avatar
5 votes
1 answer
784 views

Using collations with JSONB

I have a postgres database and a case insensitive collation. The collation was created by CREATE COLLATION IF NOT EXISTS case_insensitive (provider = icu, locale = 'und-u-ks-level2', deterministic = ...
Pux's user avatar
  • 151
6 votes
3 answers
919 views

Why are unquoted identifiers upper-cased per SQL-92?

Section 5.6 of the SQL-92 standard contains rules 10...13 per which unquoted identifiers should be upper-cased, so foo becomes FOO but "foo" remains foo. These rules are respected by Oracle, ...
Sergei Morozov's user avatar
3 votes
1 answer
1k views

Postgres nondeterministic collation performance

After reading documentation I thought I should ask about the performance issues with the case insensitive behavior I am looking for. For context, I am working on a migration project from SQL Server to ...
neveratdennys's user avatar
2 votes
1 answer
399 views

SQL Server PATINDEX issue/bug when using different case-sensitive collations

I have a function (which I found here years ago) that uses STUFF / PATINDEX to strip out non-alphanumeric characters from a string. When running on a Case Insensitive collation, it works fine. ...
Jay Austin's user avatar
4 votes
2 answers
3k views

MySQL What charset/collation for Case insensitivity and Accent sensitivity?

I am looking for a charset/collation that would make it so when I do a SELECT * FROM table_name WHERE username = "Warrior" It only returns me the rows where username = "Warrior", ...
lyeaf's user avatar
  • 177
1 vote
0 answers
137 views

SQL Server oddity with full-text indexing and case sensitivity and numbers

This problem may be unique to our server, but I can't tell from the symptoms where the issue may lie. My SQL Server version is Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 ...
user1693404's user avatar
-2 votes
1 answer
49 views

SQL QUESTION_Case When + LIKE % [closed]

I get an error but I don´t understand why. Does this make sense in SQL? I need the column ValidNaming to be filled with False/True if the customer (or field CommonLastName) has an invalid name. Why ...
Marina Olaechea's user avatar
14 votes
1 answer
1k views

Why does a comparison between 'tr' & 'tR' fail on a SQL Server with Vietnamese_CI_AI collation?

There seems to be something special about 'tR' in Vietnamese collation. Appreicate if anyone who knows about it can explain in simple terms. This issue was discovered during the installation of our ...
QFirstLast's user avatar
1 vote
1 answer
5k views

unknown variable 'lower_case_table_names=1'

I want enable lowercase table names so i have added to etc/mysql/my.cnf also etc/mysql/mariadb.cnf lower_case_table_name = 1 restart the service sudo service mysql restart I can acces service from ...
Ade Supriyadi's user avatar
1 vote
2 answers
3k views

Postgres Case-Insensitive search for Jsonb column tag keys

I have a requirement to obtain the rows which match given tags key and value case-insensitively. Here: Key search should be case insensitive and values may be String or Array of String. Right Now, I ...
Sushant Mane's user avatar
3 votes
2 answers
2k views

Case insensitive column names in a postgresql trigger function

I have a trigger function in PostgreSQL 12 which executes something like this: CREATE OR REPLACE FUNCTION "my_latlon_function"() RETURNS trigger AS $$ BEGIN latcolumn:= ( SELECT ...
s.k's user avatar
  • 372
0 votes
1 answer
565 views

Is it possible to specify a different collation for the data vs the entities within a single database?

I have a database with a case sensitive collation because the data inside of it should be treated as case sensitive in the context of how it's used. The entities and their column names within that ...
J.D.'s user avatar
  • 38.1k
2 votes
1 answer
960 views

postgresql 12.3 convert existing DB to use case-insensitive collation?

postgresql 12.3 in a container with Alpine Linux 3.10 I would like to convert an existing DB to use case-insensitive collation. Is it possible? I mean, without dropping it and recreating from scratch. ...
SwissNavy's user avatar
  • 121
11 votes
1 answer
11k views

PostgreSQL nondeterministic collations are not supported for LIKE

I am using Postgresql v12. I created a collation like this: CREATE COLLATION ci (provider = icu, locale = 'tr_TR', deterministic = false); I used that collation in a table: create table testtable1 ...
Banu Akkus's user avatar
10 votes
1 answer
5k views

Case-insensitive collation still comparing case-sensitive

I am currently trying to create a table with a text column which will compare case insensitive by default. This is because we have a third party program that executes a search on our database. The ...
Robin B's user avatar
  • 211
1 vote
2 answers
238 views

Primary Key issue in MemSQL doesn't support case sensitive

Creating table in MemSQL and creating composite primary key. Lets create simple table with following structure: Table User Data Name userid Primary Key (userid) And assume application support case ...
Abhishek's user avatar
2 votes
1 answer
2k views

MySQL Case Sensitive Join on Varchar

I have two tables, both with identical data types, character sets, and collation explicitly specified. CLERK CHAR(3) CHARACTER SET latin1 COLLATE latin1_bin NULL For a case-sensitive join on the ...
GWR's user avatar
  • 2,817
3 votes
2 answers
3k views

SSMS - How to do case-insensitive searches in Object Explorer

Preface: I am not referring to queries. There are numerous places in SSMS that allow for filtering, such as the Object Explorer and Profiler, but these all treat filters as case-sensitive with no ...
Elaskanator's user avatar
1 vote
1 answer
696 views

Functional Indexes in Oracle, compared to MySQL

Hoping you can help me understand a particular problem I'm facing when converting an Oracle 12c database to MySQL 5.7. For context, let's say we have a table that looks a bit like this: id ...
Molenpad's user avatar
  • 1,784
0 votes
1 answer
584 views

Select only those records that have same multiple values for a particular column if it's existing?

Below is an example of my pricing_supports table with more than 3 millions rows. There some rows having same values in the first_origin_id, delivery_id fields. If there are records with same ...
Dương Khoa's user avatar
1 vote
0 answers
632 views

Case insensitive search on Always Encrypted columns

How would one go about doing a case-insensitive search on a column encrypted with Always Encrypted? The problem arises when you encrypt email addresses for example. When encrypted, [email protected] ...
Swifty's user avatar
  • 173
1 vote
0 answers
549 views

Postgresql citext datatype unique constraint fail

I need to create a unique constraint on citext column, but it fails. Here is the example: create table test (name citext); ALTER TABLE ONLY test ADD CONSTRAINT test_name_uq UNIQUE (name); ...
Banu Akkus's user avatar
1 vote
2 answers
1k views

Functional Index LOWER PostgreSQL not working

The below SQL query runs in 2s: SELECT * FROM fb_name INNER JOIN fb_kg ON mid = subject_mid WHERE LOWER(alias) = LOWER('Polaski') AND fb_kg.relation = 'location/...
Michael Petrochuk's user avatar
6 votes
1 answer
12k views

Creating a case-insensitive and accent/diacritics insensitive search on a field

I would like to know if it makes sense to create an index combining two functions while using Full Text Search: lower(name) and f_unaccent(name) Where f_unaccent is just my wrapper to make unaccent ...
Rubén_ic's user avatar
1 vote
3 answers
3k views

Trigger or rule to convert all strings to lower case

I have about 26 applications interacting with our database, some of these will store email addresses in mixed case. Since I made the mistake of using varchar as the column type and not a case ...
David's user avatar
  • 1,185
1 vote
1 answer
2k views

SQL Server on Linux: Case Sensitivity

I haven’t yet tried out SQL Server on Linux, but I have a question regarding case sensitivity. In MySQL and Oracle (as far as I am aware) table names and database names are case insensitive on Mac &...
Manngo's user avatar
  • 2,849
11 votes
1 answer
11k views

How to use an array as argument to a VARIADIC function in PostgreSQL?

I am trying to make a case-insensitive version of json_extract_path_text(), using the citext module. I would like this to be a simple wrapper around the built-in function, the only difference being ...
Jake Feasel's user avatar
8 votes
1 answer
17k views

Equivalent of UTF8_UNICODE_CI collation in PostgreSQL

I would like a column in a table inside a PostgreSQL database (I am using version 9.6). I know of the UTF8_UNICODE_CI collation on MySQL, so I tried: CREATE TABLE thing ( id BIGINT PRIMARY KEY ...
Daniel Gray's user avatar
1 vote
0 answers
46 views

Case-folded sorting of output columns containing expressions

Using the following query as simple example, SELECT l.id, string_agg(lc.country, ' ' ORDER BY lc.country) AS countries FROM licenses l JOIN license_countries lc ON ...
Zilk's user avatar
  • 1,121
3 votes
1 answer
4k views

Can database objects be made case insensitive while keeping strings case sensitive?

In Microsoft SQL Server (2014) it is possible to choose between a case insensitive and case sensitive collation. My reason for using a case-sensitive collation would be to make "test" = "TEST" ...
Wouter's user avatar
  • 821
8 votes
1 answer
164 views

Case Sensitive Ordering within the CMS Server List

I've got to believe there's a reason for this, but for the life of me I cannot figure it out. It looks like ordering of Server Names within any Central Management Server is Case SENSITIVE, regardless ...
John Eisbrener's user avatar
6 votes
1 answer
5k views

pg_dump: No matching schemas were found

I am trying to dump a schema from Postgres 9.4, running on Cents 6.5, but I get an error: pg_dump: No matching schemas were found Here is the command I am running: pg_dump -U postgres -n "OLD-...
Nathan Foley's user avatar
1 vote
1 answer
6k views

Columns names are case sensitive on postgres

I have successfully migrated database from MySQL to PostgreSQL. While I am trying to connect with ofbiz, I am getting an error saying that "user_id" not found. When I query against postgres by ...
Jeevitha's user avatar
4 votes
1 answer
6k views

Index on column with data type citext not used

In PostgreSQL 9.4, with following schema: CREATE TABLE people ( id INTEGER PRIMARY KEY, name TEXT, junk CHAR(1000) ); INSERT INTO people(id, name) SELECT generate_series(1,100000), md5(...
José Luis's user avatar
7 votes
3 answers
19k views

PostgreSQL force upper case for all data

Is there a way to force all text data to uppercase without recurring to writing a function for every table or doing it client side?
Fabrizio Mazzoni's user avatar
1 vote
1 answer
4k views

Returning case-sensitive input of case-insensitive array match

Taking a JSON table with some simple data: CREATE TABLE jsonthings(d JSONB NOT NULL); INSERT INTO jsonthings(d) VALUES('{"id":1,"email":"[email protected]"}'); INSERT INTO jsonthings(d) VALUES('{"id":2,"...
jgm's user avatar
  • 305
1 vote
1 answer
506 views

How to deploy case-insensitive embedded firebird database?

I'm trying to find out how to create CI firebird embedded database. I've found (here) that there are some character sets each of them has one or many collations. So, UTF8 has UCS_BASIC, UNICODE and ...
Andrei Orlov's user avatar
0 votes
1 answer
3k views

Oracle case insensitive passwords seemingly ignoring SEC_CASE_SENSITIVE_LOGON

I'm trying to change the SYS password of an Oracle 11g database to be case-insensitive for legacy application reasons. My research suggests all I need to do is set the SEC_CASE_SENSITIVE_LOGON flag, ...
Kieran's user avatar
  • 195
0 votes
3 answers
4k views

Handling case-insensitive queries with case-sensitive data

What are some practices for designing a table, or queries, when it comes to case-sensitive data and case-insensitive queries? For example, I have a Products table that holds household goods, and ...
MxLDevs's user avatar
  • 339
4 votes
2 answers
878 views

SSDT 2010 and SQL70590 errors

I have Visual Studio 2010 SP1 with SSDT (with Dec 2012 update). I have created a new SQL Server project and imported objects from a database on a SQL Server 2008 R2 instance. The database has a ...
user avatar
6 votes
2 answers
35k views

MySQL case sensitive table names on Linux

Moving a MySQL database from Windows to Linux I have the problem that on Linux the names of the tables are case sensitive. This is a problem, because the Java application that I am developing can't ...
Vitaly Olegovitch's user avatar
27 votes
5 answers
133k views

How to do a case sensitive search in WHERE clause?

I want case sensitive search in SQL query. But by default, MySQL does not consider the case of the strings. Any idea on how to do a case sensitive search in SQL query?
Somnath Muluk's user avatar
11 votes
2 answers
8k views

Can PostgreSQL create a case sensitive database?

I'm porting some code from some version of Sybase to PostgreSQL. This is a C application that uses the Sybase client library. My approach is to write a translation layer that translates calls to ...
Greg Hewgill's user avatar
3 votes
1 answer
925 views

Can't create Windows Login's on a case sensitive SQL Server 2005 Instance - MSG 15401

I need to create 3 logins on a SQL Server 2005 instance: DOMAIN\aaa DOMAIN\bbb DOMAIN\ccc However two of them (aaa and bbb) fail with the following error: Msg 15401, Level 16, State 1, Line 5 ...
nojetlag's user avatar
  • 2,897
3 votes
1 answer
1k views

Casesensitive vs. Caseinsensitive Collatesequences?

I just started working with the SQLite database places.sqlite. Fact is that this database uses case sensitive collate sequences making writing queries as funny as in Oracle. I want to know, are ...
bernd_k's user avatar
  • 12.3k