Question : I haven’t yet tried out SQL Server on Linux, but I have a question regarding case sensitivity. In […]
Tag: case-sensitive
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 […]
Case Sensitive Ordering within the CMS Server List
Question : I’ve got to believe there’s a reason for this, but for the life of me I cannot figure […]
Returning case-sensitive input of case-insensitive array match
Question : Taking a JSON table with some simple data: CREATE TABLE jsonthings(d JSONB NOT NULL); INSERT INTO jsonthings(d) VALUES(‘{“id”:1,”email”:”Test1@test.com”}’); […]
Is it possible to specify a different collation for the data vs the entities within a single database?
Question : I have a database with a case sensitive collation because the data inside of it should be treated […]
Can’t create Windows Login’s on a case sensitive SQL Server 2005 Instance – MSG 15401
Question : I need to create 3 logins on a SQL Server 2005 instance: DOMAINaaa DOMAINbbb DOMAINccc However two of […]
- 1
- 2