PostgreSQL: deal with case insensitivity

Created on 2 April 2015, over 9 years ago
Updated 20 May 2023, over 1 year ago

Problem/Motivation

PostgreSQL is currently not behaving as MySQL or SQLite in terms of case-sensitivity for text. Please see 📌 Normalize how case sensitivity is handled across database engines Active for a more detailed description of the problem.

Decision questions:

  1. How often is postgresql-contrib package available on shared web hosts?
  2. Is postgresql-contrib available on most Drupal web hosting providers that support Drupal 8?

Proposed resolution

Mimic the CITEXT-extention for PostgreSQL. The CITEXT extention mimics the MySQL and SQLite behavior in terms of case-sensitiveness. By mimicing the CITEXT-extention there is no need to have the end-user install the real CITEXT-extention.

Remaining tasks

Decide
Write patch.

User interface changes

None.

API changes

None.

📌 Task
Status

Needs work

Version

10.1

Component
PostgreSQL driver 

Last updated 2 months ago

No maintainer
Created by

🇩🇪Germany bzrudi71

Live updates comments and jobs are added and updated live.
  • PostgreSQL

    Particularly affects sites running on the PostgreSQL database.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024