Questions tagged [case-sensitive]

The tag has no usage guidance.

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
165 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
166 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
0answers
35 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 ...
0
votes
1answer
27 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 ...
0
votes
1answer
62 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 ...