Question : I am currently trying to create a table with a text column which will compare case insensitive by […]
Tag: case-sensitive
Trigger or rule to convert all strings to lower case
Question : I have about 26 applications interacting with our database, some of these will store email addresses in mixed […]
pg_dump: No matching schemas were found
Question : I am trying to dump a schema from Postgres 9.4, running on Cents 6.5, but I get an […]
PostgreSQL force upper case for all data
Question : Is there a way to force all text data to uppercase without recurring to writing a function for […]
SQL Server on Linux: Case Sensitivity
Question : I haven’t yet tried out SQL Server on Linux, but I have a question regarding case sensitivity. In […]
Functional Index LOWER PostgreSQL not working
Question : The below SQL query runs in 2s: SELECT * FROM fb_name INNER JOIN fb_kg ON mid = subject_mid […]
Postgres Case-Insensitive search for Jsonb column tag keys
Question : I have a requirement to obtain the rows which match given tags key and value case-insensitively. Here: Key […]
SSMS – How to do case-insensitive searches in Object Explorer
Question : Preface: I am not referring to queries. There are numerous places in SSMS that allow for filtering, such […]
Creating a case-insensitive and accent/diacritics insensitive search on a field
Question : I would like to know if it makes sense to create an index combining two functions while using […]
Can PostgreSQL create a case sensitive database?
Question : I’m porting some code from some version of Sybase to PostgreSQL. This is a C application that uses […]
- 1
- 2