Questions tagged [case-sensitive]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
16 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 ...
1
vote
1answer
128 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 ...
3
votes
2answers
538 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 ...
1
vote
1answer
379 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 ...
0
votes
1answer
60 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 have more than 3 milions rows. There some rows having same values in the first_origin_id, delivery_id fields. If there're records with same ...
1
vote
0answers
146 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, John.Doe@gmail.com ...
1
vote
0answers
151 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); ...
1
vote
1answer
354 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/...
3
votes
1answer
3k 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 ...
1
vote
3answers
639 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 ...
1
vote
1answer
624 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 &...
7
votes
1answer
3k 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 ...
4
votes
1answer
6k 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 ...
1
vote
0answers
34 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 ...
3
votes
1answer
2k 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" ...
8
votes
1answer
121 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 ...
6
votes
1answer
2k 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-...
1
vote
1answer
3k 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 ...
3
votes
1answer
2k 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(...
2
votes
1answer
6k 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?
1
vote
1answer
2k 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":"Test1@test.com"}'); INSERT INTO jsonthings(d) VALUES('{"id":2,"...
1
vote
1answer
407 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 ...
0
votes
1answer
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, ...
0
votes
3answers
2k 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 ...
4
votes
2answers
599 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 ...
6
votes
2answers
31k 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 ...
21
votes
5answers
81k 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?
10
votes
2answers
5k 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 ...
3
votes
1answer
789 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 ...
3
votes
1answer
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 ...