[ACCEPTED]-Storing a case insensitive varchar in PostgreSQL-case-insensitive

Accepted answer

Score: 23

From the docs

CREATE UNIQUE INDEX lower_title_idx ON films ((lower(title)));

Score: 4

If the tables are not yet populated you 9 may consider simply converting to a standard 8 upper or lower case prior to doing any insertions 7 and making the field a primary key (or just 6 have a unique constraint). If the user 5 want to see his userid in the case he specified 4 this could be another column in the database.

Update:Based 3 on the updated tags I would still suggest 2 the solution I have proposed as being less 1 dependent on a particular DBMS.

Score: 4

Do note that PostgreSQL 8.4 (currently beta) will 1 have a case-insensitive text type.

Source: stackoverflow.com

Perform a Case insensitive Like query in a case sensitive SQL Server database

Laravel postgresql case insensitive

PostgreSQL: strange collision of ORDER BY and LIMIT/OFFSET

How can I resolve my collation conflict in a better way?

Make ArrayList element case-insensitive

phpmysql error - #1273 - #1273 - Unknown collation: 'utf8mb4_general_ci'

NVARCHAR storing characters not supported by UCS-2 encoding on SQL Server

MySQL Convert latin1 data to UTF8

Why are functions and methods in PHP case-insensitive?

Understand Unicode and code pages in SQL Server collations

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.