case-sensitive Archives

Case-insensitive collation still comparing case-sensitive

By adminPosted on January 8, 2023

Question : I am currently trying to create a table with a text column which will compare case insensitive by […]

By adminPosted on December 26, 2022

Question : I have about 26 applications interacting with our database, some of these will store email addresses in mixed […]

By adminPosted on November 19, 2022

Question : I am trying to dump a schema from Postgres 9.4, running on Cents 6.5, but I get an […]

By adminPosted on October 6, 2022

Question : Is there a way to force all text data to uppercase without recurring to writing a function for […]

By adminPosted on August 19, 2022

Question : I haven’t yet tried out SQL Server on Linux, but I have a question regarding case sensitivity. In […]

By adminPosted on April 13, 2022

Question : The below SQL query runs in 2s: SELECT * FROM fb_name INNER JOIN fb_kg ON mid = subject_mid […]

By adminPosted on April 5, 2022

Question : I have a requirement to obtain the rows which match given tags key and value case-insensitively. Here: Key […]

By adminPosted on March 31, 2022

Question : Preface: I am not referring to queries. There are numerous places in SSMS that allow for filtering, such […]

By adminPosted on March 21, 2022

Question : I would like to know if it makes sense to create an index combining two functions while using […]

By adminPosted on January 25, 2022

Question : I’m porting some code from some version of Sybase to PostgreSQL. This is a C application that uses […]