Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [case-sensitive]

40 questions
25
votes
5 answers

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
  • 1,064
  • 3
  • 13
  • 15
14
votes
1 answer

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 product on a "Vietnamese" collated SQL Server. One…
QFirstLast
  • 343
  • 1
  • 9
10
votes
1 answer

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 that it accepts citext as the first parameter…
Jake Feasel
  • 587
  • 1
  • 6
  • 22
10
votes
2 answers

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 dbsqlexec() to PQexec() (for example). That part is…
Greg Hewgill
  • 326
  • 2
  • 8
8
votes
1 answer

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 SELECT statements used by this program can not be…
Robin B
  • 191
  • 1
  • 6
8
votes
1 answer

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 the collation of the server acting as the CMS,…
John Eisbrener
  • 8,970
  • 5
  • 23
  • 55
6
votes
1 answer

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 ( id serial primary key, name text …
Banu Akkus
  • 199
  • 2
  • 9
6
votes
1 answer

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 function immutable. I do have an index working on:…
Rubén_ic
  • 63
  • 1
  • 4
6
votes
2 answers

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 find tables. I have changed my /etc/mysql/my.cnf…
Vitaly Olegovitch
  • 190
  • 1
  • 1
  • 7
6
votes
1 answer

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 ,name VARCHAR(120) NOT NULL COLLATE…
Daniel Gray
  • 479
  • 3
  • 7
  • 15
6
votes
1 answer

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-TODELETE-bushes" --verbose site > output_nf I am a…
Nathan Foley
  • 176
  • 1
  • 5
6
votes
3 answers

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
  • 1,790
  • 4
  • 19
  • 29
4
votes
2 answers

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 compatibility mode of 80, can't change this at the…
user507
3
votes
1 answer

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 Windows NT user or group 'DOMAIN\aaa' not found.…
nojetlag
  • 2,737
  • 8
  • 29
  • 38
3
votes
2 answers

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 column_name FROM information_schema.columns …
s.k
  • 216
  • 1
  • 2
  • 11
1
2 3