sql - Database Case Insensitive Index?

sql - Database Case Insensitive Index?

I have a query where I am searching against a string: SELECT county FROM city WHERE UPPER(name)='SAN FRANCISCO'; Now, this works fine, but it doesn't scale well, and I need to optimize it. I have…


unix - How do you do a case insensitive search using a pattern modifier using less?

It seems like the only way to do this is to pass the-i parameter in when you initially run less. Does anyone know of some secret hack to make something like this work/something to search for/i…



database - Simple password encryption

What is a good, simple encryption scheme for protecting passwords in a database? I don't necessarily need anything that's hyper-secure nor do I need anything that's lightning fast, but those things…


Reasons for SQL differences

Why are SQL distributions so non-standard despite an ANSI standard existing for SQL? Are there really that many meaningful differences in the way SQL databases work or is it just the two databases wi…


Can you make just part of a regex case-insensitive?

I've seen lots of examples of making an entire regular expression case-insensitive. What I'm wondering about is having just part of the expression be case-insensitive. For example, let's say I have a…


windows - How to make git ignore changes in case?

I'm not too sure what is going on here, but sometimes a particular file in my repository will change the case of it's name. e.g.,: before: File.h after: file.h I don't really care why this is happenin…


Ignore case in Python strings

This question already has an answer here: How do I do a case-insensitive string comparison? 10 answers What is the easiest way to compare strings in Python…


Is “>”(U+003E GREATER-THAN SIGN) allowed inside an html-element attribute value?

In other words may one use/<tag[^>]*>.*?<\/tag>/ regex to match the tag html element which does not contain nested tag elements? For example(lt.html):<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//…


sql - Case-insensitive search using Hibernate

I'm using Hibernate for ORM of my Java app to an Oracle database(not that the database vendor matters, we may switch to another database one day), and I want to retrieve objects from the database acc…


How do I change SQL Server 2005 to be case sensitive?

I hate case sensitivity in databases, but I'm developing for a client who uses it. How can I turn on this option on my SQL Server, so I can be sure I've gotten the case right in all my queries?…




case insensitive how string mysql sql name names not ignore